I will be presenting a day-long training day at SQLbits Pre-Con on 31 March 2019 London on the topic SQL Server Performance Tuning Real-World Scenarios.
Why Execution Plan Operator Read More Rows Than Available? – Interview Question of the Week #255
Question: Why Execution Plan Operator Read More Rows Than Available?
Answer: Statistics.
Now let us learn detailed answer in this blog post.
What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254
Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
How to Disable Batch Mode in SQL Server? – Interview Question of the Week #252
My immediate reaction was why would you disable batch mode in SQL Server when it is really is an awesome feature for performance
SQL SERVER – 5 Resources from SQLPASS 2019 – Seattle
I presented a session on Query Optimizer. In this blog post, we will see 5 important resources related to my session at SQLPASS 2019.Â
SQL Server Performance Tuning Recorded Class – 40% Discount for 4 Days
The SQL Server Performance Tuning Recorded Class will be available for the next 4 days at a rate of 40% discount. Act Now – Only 50 Seats!
Analyzing SQL Server Query Plans – Pluralsight Online Video Course
I got the opportunity to work on the area of SQL Server Performance Tuning have built a video course on the topic of Analyzing SQL Server Query Plans.