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, Part 5: Practical Answers
Practical SQL Server interview questions cover administration, settings, replication, string functions and data integrity. Compare small examples of string replacement and row counting, and keep each answer within its intended scope.
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.
geometry STContains: Check Boundary Membership
geometry STContains differs from STIntersects at a polygon boundary. Four literal points expose the intended inclusion rule without treating ordinary language as a spatial predicate.