Scripts

SQL SERVER – Missing Index, Unused Index and Duplicate Index Script
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extension Script


SQL SERVER – Introduction to Service Broker and Sample Script
SQL SERVER – Find Gaps in The Sequence
SQL SERVER – Download Script of Change Data Capture (CDC)
SQL SERVER – List All Missing Identity Values of Table in Database


SQL SERVER – 2005 – 2008 – Delete Duplicate Rows
SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
SQL SERVER – Introduction to JOINs – Basic of JOINs