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…
T-SQL script to delete the duplicate records in the table /* Table Schema*/ CREATE TABLE [dbo].[SalesData]( [FiscalYear] [float] NULL, [SalesRegion] [nvarchar](255) NULL, [SalesAmount] [float] NULL ) ON…
T-SQL Interview Question: How to Find the Second Highest Salary When it comes to SQL interviews, one of the most commonly asked and deceptively tricky questions is: “How do you…