June 24, 2009 at 12:25 pm
balbirsinghsodhi (3/4/2009)
I know it does not matter but my question is why using rebuild index command does not make logical fragmentation to 0%.May be it is related to filegroup space issue ?
I think I'm having similar issues. Here's a thread that I started today.
http://www.sqlservercentral.com/Forums/Topic740441-5-1.aspx#bm740469
I'm very interested in finding a resolution to this. 😀
June 25, 2009 at 7:38 am
1) IIRC, Microsoft's recommendation is to not even bother defragging tables with less than 1000 pages
2) For sizeable tables, if you don't have sufficient free space in the database of the pages to be laid down contiguously (which pretty much no one has unless they have been told explicitly to be proactive about file size and not allow autogrowth to manage it), thus rebuilds will have little hope of getting fragmentation anywhere near zero.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply