Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

April 2008 - Posts

Tuesday, 29 April 2008 11:42 AM

Duplicate indexes

SQL Server curiously allows duplicate indexes to be created on a table with precisely identical definitions. There is absolutely zero benefit from this practise yet significant harm can result - including: Performance degradation from maintenance
posted by Greg_Linwood | 1 Comments
Sunday, 27 April 2008 9:05 PM

Which query is scanning that index?

SQL 2005's db_dm_index_usage_stats DMV allows DBAs to analyse how often indexes are being used (or not used), including individual counts for seeks, scans & lookups on each index in your database. I was thrilled when I first saw this DMV as there
posted by Greg_Linwood | 4 Comments
Filed Under: ,
Friday, 18 April 2008 1:04 AM

update to usp_helpindexusagestats

Here's an update to the utility SP [usp_helpindexusagestats] I posted a few weeks back, in response to a comment from Mitch Wheat that he was receiving empty result sets, which could have occurred if the original version was run against a system with
posted by Greg_Linwood | 0 Comments
Filed Under: ,
Friday, 4 April 2008 1:36 AM

How SQL Server could help save the environment..

Millions of database backups are performed every day & night around the world, consuming mountains of disk space & generating massive levels of power consumption as enormous numbers of bytes are copied to disk, then to tape or other removable
posted by Greg_Linwood | 9 Comments