T-SQL – SQL Circuit

How to Get All SQL Server Error Codes and Messages Using T-SQL

When working with Microsoft SQL Server, understanding system errors is crucial for effective debugging and troubleshooting. SQL Server comes with…

SQL Server acts as a secure, high-performance backbone for business data, ensuring Power BI has accurate and up-to-date information to…

Below is the T-SQL query which will give list of all the database schema(s) created by user. It will exclude…

Following are the reaons that why UDF degrade query performance:1) User defined function calls each row & get the data…

We can check truncation/ all rows deleted status by using the below query. E.g. Employee is a table. SELECT object_Name(object_id)…

We will use sp_MSforeachdb procedure which is an undocumented procedure that allows you to run the same command against all…

Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…

USE MSDB; GO –Declaring Variable DECLARE @job_id UNIQUEIDENTIFIER DECLARE @Cnt INT DECLARE @Min INT –Declaring Table Variable DECLARE @SQLAgentJob (…

To do unattended tasks like if error comes need to disable the job. In this case, we need to disable…

Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…

To achieve the requirment of loading data from Source table to Target table with ensuring it will pull only data…

We can use a stored procedure/T-SQL statements having linked server & DB name as variables to get the data dynamically…