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.
SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement
An interview puzzle: write one UPDATE that flips male to female and female to male. Can you swap value of column data without a CASE statement?
SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?