usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

/*
Author : Brahmanand Shukla (SQLServerCarpenter.com)
Date : 27-May-2022
Purpose : To get all the stored procedures and triggers missing the use of SET NOCOUNT ON.
This procedure may be helpful in performance tuning assignments.

Example:
EXEC usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
*/
CREATE OR...

My book “Learn T-SQL from Scratch” is launched

A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...

My book “Learn T-SQL from Scratch” is launched

A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...

Script to create copies of the existing object

Many a time we need copies of an object but with different names. I also got a requirement to process the files in parallel using SSIS. We had already...

Divide the rows of a column in equals batches in grid format

I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...

Get the month end dates of last N years

Here is a simple T-SQL script that may come handy if you need the month end dates of last N years. N is the number of years. The output...

Divide the rows in equals batches

Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...

Get the month end dates of last N months

Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...

SSIS Logging – Linking sysssislog with custom log

I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...

Query to find Nonclustered Index clashing with Clustered Index

It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...