Aussie SQL Server Bloggers is a blog site for Australian SQL Server User Group member blogs.
If you'd like to join the bloggers role, please forward an email to blogs@sqlserver.org.au, containing your member name & we'll get you blogging in no time!
Front Page News
-
|
|
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...
|
-
|
|
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...
|
-
|
|
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...
|
-
|
|
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...
|
-
|
|
Here's an index analysis script I put together recently which combines output from sp_helpindex (also with included columns, which the regular sp_helpindex lacks) and the dm_db_index_usage_stats() DMV.
I use this script primarily to identify which indexes...
|
There are
5 guest(s) online.
Currently there are no online users.