What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.
SQL SERVER – Interesting Interview Questions – Revisited
Readers took my Interesting Interview Questions test seriously. See who got the correct answer, and why good T-SQL mattered more than the schema.
SQL SERVER – Interesting Interview Questions – Part 2 Puzzle Solution
The Part 2 puzzle solution: find each person who has every selected color, using INNER JOIN, GROUP BY and HAVING COUNT, with the full script.
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
None of the 40 candidates I interviewed solved this simple puzzle, one of my interesting interview questions: find each person who has all the selected colors.
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
An interview question: how do you find a table row count without using T-SQL or opening the table? SSMS table properties show it on the Storage page.
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications – 2
My roadmap of Microsoft Certifications for SQL Server: why certificates matter, how they are structured, exam preparation, registration and the benefits.
SQL Server – 2008 – Cheat Sheet – One Page PDF Download
A one-page SQL Server 2008 cheat sheet PDF with the commands DBAs and developers use every day. Print it on A4 and keep it handy.