During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes. Question: What actually are Query Optimizer Fixes under Database Scoped Configurations? Should we turn Query Optimizer Fixes? Answer: Before I answer this question, please note that this feature is introduced in SQL Server 2016. So if you are using any other version of…
The following two indexes are redundant in most SQL databases: It is usually safe to drop the first index, because all queries that query the LAST_NAME column only can still profit from the second index I_ACTOR_2. The reason being that LAST_NAME is the first column of the composite index I_ACTOR_2 (it would be a different […]
If you are on a urge to learn towards SQL internals and want to think in SQL way then this would be the training that you would look out in SQLSkills. This team doesn’t need any introduction to SQL world and they bring immense knowledge to share with SQL community. Having attended lot of online and SQL Saturday sessions from this team, this training will set your SQL standard to next level.
I would like to attend the following training class IEPTO2: Performance Tuning and Optimization – Part 2 class in Chicago, October 9-13, 2017 which will definitely help me understand the core issue faced in my current job role (Wait Stats and Query plan change) and resolve it.
Lastly whoever makes it to the class will definitely say ‘Got more than what i expected’ and if i would get the chance to make it then i would wish to say the same word.