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.
SQL SERVER – Last Used Stored Procedure
“Is there any way to know the last used stored procedure in SQL Server?” Well, I was asked this during Health Check.Â
Snowflake – Stored Procedure Template in JavaScript
Many SQL developers do not know it well. For everyone to use, I am going to share the Stored Procedure Template in JavaScript for Snowflake.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.