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
SSAS Multi-Dimensional Cube Storage Modes Below is the SSAS cube storage table which is helpful in choosing the right storage mode for your application based…
T‐SQL: MERGE statement – Single statement for Insert + Update + Delete operation 1. Background MERGE is a new feature of SQL Server 2008 that provides us an efficient way to perform multiple…
How to create Connection String using Notepad 1. Background The purpose of this document is to describe how to create connection string for OLE DB provider and…