Puzzle 3 of 31 is about understanding identity values in SQL Server. My co-author Vinod Kumar and I share hints to help you with the quiz question.
SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31
Quiz 2 of 31 from our interview book asks about the various kinds of triggers. Vinod Kumar and I share a few hints before you pick your answer.
SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31
Part 1 of a 31 part SQL quiz based on my interview book. Vinod Kumar and I give hints to help you answer a question on ANSI isolation levels.
SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users
What does the number of users in database properties really mean? Current connections, or something else? A small reader question for the holidays.
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
An interview riddle: create two columns but give a datatype only once, and copy data without UPDATE. A computed column solves it simply.
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
The solution to my puzzle: how to simulate LEAD() and LAG() with a T-SQL self join, without the SQL Server 2012 analytic functions.
SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example
Win a print book: explain the value of PERCENTILE_CONT with a simple example, and learn this SQL Server 2012 function even on an earlier version.