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
Inside SQL Server: Navigating Error Logs via the File System When SQL Server encounters issues, the error log is often the first place to look for answers. While many use…
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…
SSRS Performance Issue – Large SSRS report causing restart of server Following things can be checked to resolve the issue: 1) Run the report query in SSMS and see whether it…