Service Pack 1 is now available for SQL Server 2005. You can download it here.
Here is the list of the new features and improvements included in this service pack.
Database Mirroring is enabled in this service pack!
A while ago, I posted my DBCC DBREINDEX and DBCC INDEXDEFRAG stored procedures. They perform the DBCC operation on all indexes in the database, which is probably not a good idea. This article provides an abundance of data as to why. Paul Randal, Lead Program Manager at Microsoft for SQL Server Storage Engine and SQL Express, gives additional information in this thread.
So how does one decide when performance degradation is caused by index fragmention?
Paul Randal's response: “All you need to do is see which queries are using which indexes for range scans rather than singleton lookups. These are the indexes that you...