Posted by Erland Sommarskog on 12/28/07 08:31

Neil (nospam@nospam.net) writes:
> Here's the full output. Will reply to the rest later (am out the door...).

OK, the numbers looks good, beside the extent scan fragmentation that is.
But it's not that your pages are half-full or something like that.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Query - Select two tables where a.id=b.id
• Prev in forum: Query - Select two tables where a.id=b.id
• Thread view: Re: Database Tripled In Size!!

[Reply to this message]