Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Defragmenting?
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Miscellaneous
Thread ID:
00398859
Message ID:
00398934
Views:
10
If DBCC SHOW_CONTIG shows a lot of fragmentation for a specific table, the only way to reallocate the pages is to drop and recreate the clustered index. Running a defrag tool on the drive will have no effect since SQL Server manages the space with the data file, not NT.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform