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.
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.