SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes — SQL Authority with Pinal Dave

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…

via SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes — SQL Authority with Pinal Dave

Tune Yourself to Optimize SQL Performance

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.