The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check
Automate Data Workflows with SQL Server Stored Procedures – Video Course
Automate Data Workflows with SQL Server Stored Procedures is aimed at enhancing your skills in creating, fine-tuning, and securing SP.
Capturing Stored Procedure Executions with Extended Events in SQL Server
We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.
SQL SERVER – Resolving Deadlock by Accessing Objects in the Same Order
In Understanding SQL Server Deadlocks, I mentioned that one way to avoid or resolve deadlock is by accessing objects in the same order.
Using Stored Procedure in SELECT – SQL in Sixty Seconds #193
Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.
SQL SERVER – Using Stored Procedure in SELECT Statement
A very popular question I often receive during my Performance Health Check is about how to use stored procedures in SELECT Statement.
SQL SERVER – Script to Estimate Compression
I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.