The solution to my quick puzzle on JOIN and NULL. Many readers said the puzzle had an error; it did not, and here is the answer that works.
SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
A relaxing SQL Brain Teaser on INNER JOIN and NULL: set up a sample table, look at the result, and fill in the missing T-SQL that produces it.
SQL SERVER – INNER JOIN Returning More Records than Exists in Table
Can an INNER JOIN returning more records than exist in a table be right? Jeff thought it was a bug. Our chat shows why it is possible and natural.
SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
The first SQL in Sixty Seconds video shows how to convert subquery to CTE in about a minute. Short, easy tips from my co-authors and me.
SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2
A new DBA on his first day could not find the SQL Server installation log summary. Here is the file location for SQL Server 2012 and 2008 R2.
SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed
Database diagram support objects cannot be installed because this database does not have a valid owner. Here is the quick fix I used on a friend’s database.
Testing a Failover Before You Need One
Testing a failover reveals connection, data, job, and recovery gaps before an outage; learn to plan a SQL Server drill and record the result.