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
T-SQL script to get long running queries in SQL Server Background: The purpose of this article is to provide a simple way of getting a list of all the concurrently…
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…
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…