SQL Server – How to get a alert or notification if SQL Query is taking more than 5 mins
DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @duration INT –Capture timestamp for start of execution SET @StartTime = GETDATE() –…
Author: Team SQL Circuit
SSRS – How to migrate Report Subscriptions from one server to another server
SQL Server always create Subscription jobs in the instance where reporting service is installed/Configured. Or we can say SQL server…
SQL Server – How to reorganize indexes in SQL Server Database
Reorganizing the indexes consists of two processes 1) Detect the fragmentation: By using the system function sys.dm_db_index_physical_stats, you can detect…
SQL Server – How to run a query for all the database(s) in SQL Server Instance
We will use sp_MSforeachdb procedure which is an undocumented procedure that allows you to run the same command against all…
SSRS – Representation of data in Parent child relationship
For showing the data in Parent Child relationship, we need to create grouping. Let’s take an example of Product Category,…
SQL Server – Reason for stored procedure not returning any data
Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…
Representation of data in Table & Matrix & Correlation
The objective of this article is provide a visualization for data in tablix as well as matrix and how we…
SSRS: How to put filter at visual level
Here is the sample Sales Report which shows Region & Year wise Sales Amount. If we want to put…
SSRS Reporting – How to add a Reference Line in Line Chart
Sometimes, requirement comes to add a reference line in the line chart which will act as benchmark to measure the…
High Level Architecture of Web & Database Server with Load Balancing & High Availability
1) Web application would be hosted on 2 web servers -Web Server 1 and Web Server 2. 2) Both the…
SQL Server Agent – How to enable SQL Agent Job using T-SQL script
USE MSDB; GO –Declaring Variable DECLARE @job_id UNIQUEIDENTIFIER DECLARE @Cnt INT DECLARE @Min INT –Declaring Table Variable DECLARE @SQLAgentJob (…
SQL Server Agent – How to disable SQL Agent Job using T-SQL script
To do unattended tasks like if error comes need to disable the job. In this case, we need to disable…