I asked every candidate the difference between HAVING and WHERE clause, and none got it right. HAVING filters groups, while WHERE filters individual rows.
SQL SERVER – Database Coding Standards and Guidelines Part 2
Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.
What Hiring Managers Look for in a DBA
Hiring managers look for DBAs who can restore data, stay calm under pressure, explain tradeoffs, and show evidence of sound operations.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL Server Interview Questions and Answers Complete List Download
The SQL Server Interview Questions and Answers Complete List Download collects my six part series in one PDF, as many readers asked.
SQL Server Interview Questions and Answers Part 6
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.