FizzBuzz is a common interview puzzle: print 1 to 100, with Fizz for multiples of three and Buzz for five. Here is my T-SQL answer using a WHILE loop.
SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
A reader was sure he found a severe bug that causes data discrepancy. Run his script and see why it is not a potential bug in SQL Server at all.
SQL SERVER – Interview Questions – Difficult SQL Puzzle
Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation
Solution to the Computed Columns Datatype Explanation puzzle: if a computed column comes out as TINYINT, here is how to create it as INT instead.
SQL SERVER – Puzzle – Computed Columns Datatype Explanation
Jacob Sebastian explains that SQL Server casts to the data type with the highest precedence. That leads to my puzzle on computed columns datatype.
SQL SERVER – Simple Puzzle Using Union and Union All – Answer
The answer to yesterday’s Simple Puzzle Using Union and Union All, explained with an image. My UNION vs. UNION ALL article explains why it works.
SQL SERVER – Simple Puzzle Using Union and Union All
A simple puzzle using UNION and UNION ALL: guess the output of two short scripts before you run them. The hint is my article on UNION vs. UNION ALL.