The day 3 quiz is on the clustered index and primary key. Answer it through the contact form for a chance to win the Joes 2 Pros combo worth USD 198.
SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5
Day 2 of the contest brings a question on identity fields. Read the hints, send your answer and you could win a Joes 2 Pros kit worth USD 198.
SQL SERVER – Query Hint – Contest Win Joes 2 Pros Combo (USD 198) – Day 1 of 5
Day 1 of our contest: answer a question about the query hint and you could win the Joes 2 Pros 5 book kit worth USD 198. Open to USA and India.
SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always
A beginner asked why a query returns results sometimes but not always. I share where I would start looking and invite you to add your own answer.
SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables
Madhivanan asked how to tell if a table has a uniqueidentifier column without querying system tables or DMVs, knowing only the table name.
SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function
A reader’s swap puzzle solution used SOUNDEX, so many asked how it works. I explain the SOUNDEX function and DIFFERENCE function with simple examples.
SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement
Readers sent more than 50 answers to my swap puzzle. Here are 5 different ones that swap a column value without CASE statement, plus my own three.