Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

April 2006 Blog Posts

SQL Server 2005 Service Pack 1

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!

posted @ Wednesday, April 19, 2006 10:49 AM | Feedback (6) | Filed Under [ SQL Server - Database Administration ]

Index Fragmentation

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...

posted @ Tuesday, April 11, 2006 3:33 PM | Feedback (2) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET