Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-05 : 09:13:49
|
| Hanan writes "We are trying to use the updateable partition views in SQL 2K EE, and we will have a rolling window of 3 months of data.We are going to drop the underlying table that is older then 3 months, and create a new table and the updateable view every month end. I’m a bit concern about fragmentation issues that might occur due to this issue, and how can we solve it once it’s happened. Is there any type of coalescing commands to be used? The size of the monthly data might change between months, and we are not using file groups for the underlying tables. Is there any DBCC command to find such a fragmentation issues?" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-05 : 10:44:58
|
| Check for DBCC SHRINKDATABASE in BOL.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
butlermi_11
Starting Member
10 Posts |
Posted - 2002-02-05 : 11:40:44
|
| Try using DBCC SHOWCONTIG [ ( table_id [, index_id] ) ]For further information look it up in BOL. |
|
|
|
|
|
|
Fragmentation Issues