Interview Questions and Answers Part 6 covers the six properties of relational tables and de-normalization, adding redundant data to help performance.
SQL Server Interview Questions and Answers Part 5
Interview Questions and Answers Part 5 covers renaming a database with sp_renamedb, sp_configure versus SET commands, and the types of replication.
SQL Server Interview Questions and Answers Part 4
Interview Questions and Answers Part 4 begins with SQL Profiler: what it is, how it captures events to a file or table, and how to keep traces small.
SQL Server Interview Questions and Answers Part 3
Interview Questions and Answers Part 3 opens with NOLOCK: how the hint skips read locks, why that means dirty reads, and what it does for concurrency.
SQL Server Interview Questions and Answers Part 2
Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.
SQL Server Interview Questions and Answers Part 1
Interview Questions and Answers Part 1 starts with the basics: what an RDBMS is and what normalization means. The updated set now lives at a new location.
SQL Server Interview Questions and Answers Introduction
Interview Questions and Answers Introduction: why I started this six part series after many reader requests. The updated questions now live at a new location.