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
-
|
|
Paul Randal has called me out today in the "Things you know now" series of blogs that is presently moving through the SQL Server blogsphere. I'm usually in awe of Paul's ability to churn interesting information out at a fast pace about SQL Server...
|
-
|
|
David Lean (SQL Server Technology Specialist at Microsoft Australia for many years) began a highly informative SQL Server blog last year - "Dave Does Data": http://blogs.msdn.com/davidlean
In a monster post today, Dave documents the techniques he...
|
-
|
|
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...
|
There are
4 guest(s) online.
Currently there are no online users.