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 – Advantages of SQL Server Analysis Service (SSAS) over Traditional RDBMS 1. Super Fast Queries Even with millions of rows, reports load instantly.Benefits: 2. One Source of Truth All users access…
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…
How to get the DDMMYYYYHHMMSSMMM and YYYYMMDDHHMMSSMMM date formats in SQL Server. Below are the SQL statements by which we can get the required formats: DDMMYYYYHHMMSSMMM format : SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(),…