Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:
EXEC sp_recompile ‘NameofSP’
Let us read more about it.
SQL SERVER – Parameter Sniffing and OPTIMIZE FOR UNKNOWN
I consider myself fortunate that I receive a follow-up question from my blog posts. Let’s discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN.
SQL SERVER – Parameter Sniffing and Local Variable in SP
The question I had received was about Parameter Sniffing and Local Variable in Stored Procedure. Let us learn about it in this blog post.
SQLBits Training Day – SQL Server Performance Tuning Real-World Scenarios
Join my SQLBits Training Day on 31 March 2020 in London: SQL Server Performance Tuning Real-World Scenarios, a full day pre-con.
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