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 create incremental drop script by using MS Build and SQLPackage utility 1. Background The purpose of this document is to provide a way of creating incremental drop script with respect to…
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…
SQL Mathematica – Powering Algebra in SQL: Evaluating Binomial Squares The algebraic identity (a + b)² = a² + 2ab + b² is a foundational formula in mathematics, commonly used…