What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.
SQL SERVER – Execution Time of Stored Procedures
How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
SQL SERVER – Get Column Names
A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.
Hide Code in SSMS – SQL in Sixty Seconds #154
I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.
SQL SERVER – Hide Code in SSMS
Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.
SQL SERVER – Delayed Durability and Flushing Log Files
Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
SQL SERVER – Stored Procedure Parameters and Single Quotes
Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.