SQL Puzzle Archives - Page 20 of 27 - SQL Authority with Pinal Dave

The red arrow indicates the use of the LEAD and LAG window functions.

SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG

November 16, 2011

Win a print book: write a T-SQL self join that simulates LEAD and LAG, so you can learn a SQL Server 2012 feature even on an earlier version.

SQLAuthority News – Updates on Contests, Books and SQL Server

November 8, 2011

Pinal Dave

SQL Puzzle

My updates on contests and book giveaways in one place, including the extended deadline for the Joes 2 Pros combo set contest, now Nov 10th 7 AM.

Results window in sql server management studio.

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

October 19, 2011

Pinal Dave

SQL Puzzle

SQL Scripts

A T-SQL brain trick: three SELECT statements are separated by lines of underscores, and running one of those lines alone gives Msg 2812. Can you explain why?

SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

October 8, 2011

Pinal Dave

SQL Puzzle

An update on my SQL Server Quiz 2011 question, All was well few moments before all went wrong: I now give away two SQL Wait Stats print books.

Puzzle – Usage of New Index Hints – ForceSeek and ForceScan

September 23, 2011

Pinal Dave

SQL Puzzle

Query Hint, SQL Index, SQL Server

SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.