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
SSIS – Data Flow Diagram for consuming Web API using OAuth In Microsoft technology platform, we can use SSIS package to consume the Web API. We need to use the script…
Database Migration from SQL Server 2000 to 2008/2008 R2/2012 1. Background: The purpose of this article is to lay out the structure for database migration from SQL 2000/2005 to…
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() –…