1-800-269-3227 info@sqltuners.net

Auto Update Statistics – good or bad?

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

How many indexes does my table need?

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

Welcome to the SQL Tuners blog

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