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 – DTS to SSIS Migration 1. Need of DTS to SSIS Migration DTS was first released with SQL Server 7.0 with a objective of helping…
How to Delete a SQL Server Database Safely A SQL Server database may be deleted when it’s no longer needed, such as after migration, project completion, or in…