My SEQUENCE puzzle part 3 involves some service related steps, so run it only on a test machine, never on production. Can you guess the next value?
SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 2 of fun with SEQUENCE: the same script as before, but without MINVALUE. Now guess the next value SQL Server 2012 returns after the cycle.
SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?
SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117
NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.
SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST
A Saturday fun puzzle with DATETIME2 and CAST in SQL Server 2012. Run each script one at a time, guess the output, and learn something new.
SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE
Learn to write a hierarchical query using a recursive CTE with a short video and a quiz on an employee and manager table. Check your answer.
SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function
Can one table, used once, give 2 join operators in an execution plan? Readers used ranking functions, and my own answer relies on index intersection.