T-SQL script to get list of tables which dont have clustered index August 12, 2013 SELECT name AS Table_Name_WithoutClusteredIndex FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO
SSIS – Performance issue with SQL Sever Agent Job exeuting SSIS packages Following are the suggestions: 1) If your SSIS server is shared instance then there could be possibility that your IO/memory…
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…
T-SQL Programming – Stored procedure for Error handling Error handling is an important aspect of any programming language. Like other programming languages, in T-SQL programming also, we use…