SSAS – Performance issue with Date Dimension
When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…
Category: SQL Server
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() –…
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 – 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…
SQL Server High Availability – How to capture Server(s) status whether it is online or offline using T-SQL programming
Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…
SQL Server – How to get data from multiple linked server
We can use a stored procedure/T-SQL statements having linked server & DB name as variables to get the data dynamically…
Explanation of SQL Server Error Message – “String or binary data would be truncated”
The error message “String or binary data would be truncated” tells we are trying to put a longer string into…
SSRS – How to remove the duplicate values from the report input parameter
If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT…
SQL Server Case Sensitivity
SQL Server is, by default, case insensitive, which means the word “SQL SERVER” or “sql server” will be same for…
SQL Server – Error handling and Transactional handling in T-SQL programming
Below is an example showing how to use Error handling as well as Transactional handling in TSQL programming. 1) When…
Auditing, Tracking, and Change Monitoring Technologies in SQL Server
1. A Common Conversation about Auditing a. What was the value of this particular field ? b. How many…
T‐SQL: MERGE statement – Single statement for Insert + Update + Delete operation
1. Background MERGE is a new feature of SQL Server 2008 that provides us an efficient way to perform multiple…