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
T-SQL script to get long running queries in SQL Server Background: The purpose of this article is to provide a simple way of getting a list of all the concurrently…
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…
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…