My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.
How to Copy Files in SQL Server? – Interview Question of the Week #257
Question: How to Copy Files in SQL Server?
Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.
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.
SQL SERVER – Parameter Sniffing Simplest Example
Today we will see a very simple example of the Parameter Sniffing. Let us see a very simple example of the parameter sniffing.
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
SQL SERVER – Extended Event to Capture Memory Grant Feedback
In this blog post, we will learn about the extended event to capture memory grant feedback. I created this extended event during recent consultancy.