Blog
Auto Update Statistics – good or bad?
As we all know, table statistics are a critical resource that the optimizer uses in determining a good query plan. Not just that they exist but that they are up to date and as accurate as it can be. Statistics provide the optimizer algorithm with the essential data...
How many indexes does my table need?
While the question "How many indexes should I have on my tables?" is good and one I get asked about a lot, it is not necessarily an easy one to answer as not all answers are correct for every environment. So care needs to be taken when designing an indexing strategy...
Welcome to the SQL Tuners blog
Welcome to our new blog! Over the coming months we will be adding content here covering topics from best practices to real world, in-the-field issues we run across as we strive to get the most out of SQL Server installations across the industry. Look for new articles...