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.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
SQL SERVER – 7 Resources From Techorama Netherlands 2019
In this blog post, I will include a few resources which I promised during my presentations at Techorama Netherlands 2019.