I consider myself fortunate that I receive a follow-up question from my blog posts. Let’s discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN.
The question I had received was about Parameter Sniffing and Local Variable in Stored Procedure. Let us learn about it in this blog post.
Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
In this blog post, we will learn about the extended event to capture memory grant feedback. I created this extended event during recent consultancy.
At that point, I realized that I should have a blog post that explains to easy way to recompile stored procedures. Today, we will learn about 2 methods.
Question: How to Use GOTO command in SQL Server?
Answer: Let us see a simple example of how GOTO works in SQL Server in this blog post.