March 7, 2012 at 11:48 pm
I have a database which has high fragmentation . i ran the Re index on the database how ever the high fragmentation is still there. Can any one please suggest me what to do here.
Thanks.
March 7, 2012 at 11:57 pm
What did you do exactly? Which statements did you use?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 12:50 am
we used the following query
Alterdatabase database Name with Reindex . THis was a maintainance plan that was created. We have a high amount of Data insert, updation and deletion.
March 8, 2012 at 12:57 am
iamsam.sandeep (3/7/2012)
.... i ran the Re index on the database how ever the high fragmentation is still there. .
How big is this table? If the table is too small, defrag may not have any impact.
Do you have clustered index on the table?
Did you shrink the file after defrag?
March 8, 2012 at 12:58 am
I can't seem to find any official documentation of that command.
You're sure you didn't issue an ALTER INDEX or DBCC command?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 2:06 am
We have clusterd index on the Table.
March 12, 2012 at 2:07 am
We used the Alter Statement.
March 12, 2012 at 4:48 am
What was the exact command that you used? How big are the tables in question (how many pages)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply