SQL Puzzle Archives - Page 23 of 28 - SQL Authority with Pinal Dave

My friend and SQL Expert Vinod Kumar asked a very interesting question in his latest blog post. Quick Quiz:Do you need the primary data file available to backup your transaction log after a crash? This question can have multiple answers. While he asked the question on blog, I was sitting…

SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer

March 15, 2011

My friend Jacob Sebastian has SQL Server Quiz 2011 launched. This time when he asked me to come up with quiz question – I wanted to come up with something which is new and make participant to think about it. After carefully thinking I come with question which I really…

SQL SERVER – Solution – Challenge – Puzzle – Usage of FAST Hint

December 6, 2010

Earlier I had posted quick puzzle and I had received wonderful response to the same from Brad Schulz. Today we will go over the solution. The puzzle was posted here: SQL SERVER – Challenge – Puzzle – Usage of FAST Hint The question was in what condition the hint FAST…

SQL SERVER – Puzzle – Error While Converting Money to Decimal

December 5, 2010

SQL Puzzle

SQL Datatype, SQL Scripts, SQL Server

Earlier I had posted quick puzzle about Converting Money and I had received a wonderful response to the same. Let us go over the solution.

The puzzle was posted here: SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal

SQL SERVER – 3 Simple Puzzles – Need Your Suggestions

December 1, 2010

Last Month, I have posted three Simple Puzzles and I got very good response. I think there can be many interesting answers there. I would like to request all of you to take part the puzzles and provide your answer. I plant to consolidate answers and publish all the valid…

SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists

November 28, 2010