Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.
SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE
Learn to write a hierarchical query using a recursive CTE with a short video and a quiz on an employee and manager table. Check your answer.
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani
Object names in SQL Server can be up to 128 characters, but local temp tables stop at 116. Guest author Balmukund Lakhani explains this limit for Temp Objects.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL SERVER – Microsoft Certification – SQL Server 2012
Microsoft Certification changed for SQL Server 2012. A simple map of the new MCSA and MCSE path and of exams 70-461, 70-462 and 70-463.