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…
Category: SQL Server
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…
SSIS – Data Flow Diagram for consuming Web API using OAuth
In Microsoft technology platform, we can use SSIS package to consume the Web API. We need to use the script…
T-SQL Programming – Stored procedure for logging Error(s) in the ErrorLog table
Error handling is an important aspect of any programming language. Like other programming languages, in T-SQL programming also, we use…