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
How to Get All SQL Server Error Codes and Messages Using T-SQL When working with Microsoft SQL Server, understanding system errors is crucial for effective debugging and troubleshooting. SQL Server comes with…
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…
How to process OLAP Cube using SQL Server Agent Job 1. Background The purpose of this document is to describe a way of processing OLAP cube using SQL Server Agent…