Most Recent Blog Posts

06/04/2010 - 4:08pm

MERGE Puzzle and a Request for Warning

Itzik describes certain use of the MERGE statement that can lead to unexpected results and points to a connect item that asks for a warning in such....More
06/01/2010 - 2:44pm

Solutions to Related Tables Challenge

Itzik covers solutions to last week’s T-SQL challenge – Related Tables....More
05/27/2010 - 1:42am

T-SQL Challenge - Identifying Related Tables

Itzik provides a T-SQL challenge where you need to write a query that identifies tables related to an input table....More
04/30/2010 - 6:53pm

Packing Date Intervals

Itzik describes a technique to pack overlapping date intervals....More
04/07/2010 - 4:36am


Itzik is moving to the USA with his family to start a new chapter in life and talks about the planned trip....More
03/27/2010 - 4:50am

Splitting Separated Lists of Integers with HIERARCHYID

Itzik tries a new technique to split separated lists of values using the HIERARCHYID data type....More
03/17/2010 - 6:37am

Aggregate Over Columns

Itzik discusses solutions to a task involving calculating aggregates over a set of column values (as opposed to over a set of rows)....More
02/10/2010 - 8:58am

QUALIFY - Request for a New Filtering Clause

Itzik describes a request for a new query filter clause called QUALIFY and asks for your vote....More
What's Puzzled By T-SQL Blog?

T-SQL tips and logical puzzles from Itzik Ben-Gan.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×