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.
Silent Truncation When Building Strings in nvarchar(max) Variables
Silent truncation can happen while SQL Server evaluates a bounded expression. These examples compare the lost characters with a max expression and a max REPLICATE input. Check stored lengths before blaming a clipped display.
SQL SERVER – CASE Statement/Expression Examples and Explanation
The CASE Statement/Expression works anywhere an expression can, from the SELECT list to WHERE and HAVING. Here are its two basic forms with examples.
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Error: 18452 Login failed for user ‘(null)’ means the server only allows Windows Authentication. Switch to Mixed Mode and enable the sa login to fix it.