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
Data Profiling in SQL Server: Understanding Your Data Before You Transform It In any data-driven project, one of the most critical early steps is understanding the quality, structure, and patterns of your…
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…
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…