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
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…
SQL Server Issue – SQL Server Database struck in Recovery Mode Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…
Mastering NULLs in SQL Server: ISNULL and NULLIF Explained In SQL Server, ISNULL and NULLIF are two essential functions used to handle NULL values, but they serve very different…