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
SQL Server – Best Practices in SSIS 2012 Following are some of the best practices in SSIS which is helpful in performance optimization Hardware Infrastructure: Disks, RAM, CPU,…
SQL Server – How to get a alert or notification if SQL Query is taking more than 5 mins DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @duration INT –Capture timestamp for start of execution SET @StartTime = GETDATE() –…
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…