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
Overview of SQL Server BI Model SQL Server Business Intelligence Model basically consists of four main services i.e. SQL Server Relational services, Integration Services, Analysis Services…
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 get list of all the tables having triggers in a database with trigger name. Approach: Sys.objects table contains information about all the objects of a database We are filtering the trigger objects with TYPE…