The last quiz in the series, 31 of 31, asks what a slowly changing dimension is. Vinod Kumar and I share a few hints to help you answer it.
SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31
What are the advantages of Partitioning? Quiz 30 of 31, based on a question from my SQL Server Interview Questions and Answers book, run with Beyond Relational.
SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31
How well do you know the Data Collector in SQL Server? Quiz 29 of 31 asks about its usage, and Vinod Kumar and I share hints to help you.
SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31
Quiz 28 of 31 asks about reclaiming space back from a database. Vinod Kumar and I share a few hints so you can think it through before answering.
SQL SERVER – Lots of Date Functions – Find Right One to Use – Quiz – Puzzle – 27 of 31
SQL Server has lots of date functions; can you pick the right one? Quiz 27 of 31, built from a question in my SQL Server Interview Questions and Answers book.
SQL SERVER – Common Gotcha’s Associated with Common Table Expressions (CTE) – Quiz – Puzzle – 26 of 31
Common Table Expressions have a few gotchas that catch many developers. Quiz 26 of 31 tests them, with a few hints from Vinod Kumar and me.
SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31
Quiz 25 of 31 explores a different aspect of Policy Based Management in SQL Server. Vinod Kumar and I give hints to help you find the answer.