Today, I have very interesting scenario to share with all of you. This is a true story which I encountered in my recent Comprehensive Database Performance Health Check. It is about a very popular SQL Server setting Optimize for Ad Hoc Workloads.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to Clear Plan Cache with Scoped Configuration?
What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan? – Interview Question of the Week #122
Question: What is the Difference Between Physical and Logical Operation in SQL Server Execution Plan?
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115
Question: How to Find How Many Rows Each Query Returned Along with Execution Plan?
How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098
Question: How to find the longest running query in SQL Server with Execution Plan?
How to Send Execution Plan in Email? – Interview Question of the Week #079
A few days ago, I sent emails to everyone who subscribed to my newsletter (if you have not subscribed, you are missing out some real fun) that they can send me one performance problem of theirs like and I will help them solve it in 24 hours. I received over 1082 responses in the first 24 hours and honestly, I could not keep my commitment to reply each in 24 hours (even though I answered emails for 18 hours straight). It took me over 4 days to respond to EVERY SINGLE EMAIL, and on the top of it, I was still getting more emails. Finally, I caught up with everything on the fifth day and I had received a total of 2187 performance problems in the email. I have responded to each of them. During this marathon of answering emails, I saw that many users do not know how to send the execution plan in an email.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
In one of the recent interview, I met quite a few interesting candidates. It is common for employees ask many questions during an interview, but there are times when candidates also ask questions back to the interviewee. I was asked following question recently.
Question: Do you use Actual Execution plan or Estimated Execution plan?