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
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…