by fhergen | Apr 6, 2022 | Uncategorized
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...
by fhergen | Apr 6, 2022 | Uncategorized
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...
by fhergen | Apr 6, 2022 | Uncategorized
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...