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
SSIS 2012 – Data Flow Transformations Handout Data Flow Transformations Aggregate Conditional Split Data Conversion Derived Column Lookup Sort Merge Merge Join Multicast OLEDB Command Row Count…
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…
SQL Server High Availability – How to capture Server(s) status whether it is online or offline using T-SQL programming Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…