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 – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
SSMS comes with many built-in performance and activity reports. This sixty second video shows where to find the Standard Reports and how to run them.
SQL SERVER – SmallDateTime and Precision – A Continuous Confusion
SmallDateTime and precision confuse a lot of people. I explain what the precision really is, using a Facebook question from Raghavendra.
SQL SERVER – Renaming Index – Index Naming Conventions
Tables got renamed to a new standard, but what about the indexes? Tell me which index naming conventions you follow when renaming an index.
Changing an Index In Place With CREATE INDEX and DROP_EXISTING
Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.