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
Tiny Tweaks, Massive Gains: The Art of SQL Performance Tuning In SQL Server, performance isn’t always about major overhauls—it often comes down to the small, smart tweaks. Suppressing unnecessary row…
How to get the DDMMYYYYHHMMSSMMM and YYYYMMDDHHMMSSMMM date formats in SQL Server. Below are the SQL statements by which we can get the required formats: DDMMYYYYHHMMSSMMM format : SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(),…
How to Delete a Database in SQL Server using T-SQL Deleting a database in SQL Server using a T-SQL script is a quick and efficient method ideal for automation, scripting,…