SQL Magazine - Puzzled by T-SQL

Virtual Auxiliary Table of Numbers

Thu, 29 Oct 2009 04:00:41 MST

Itzik provides code to generate a virtual auxiliary table of numbers efficiently.

Mon, 05 Oct 2009 04:00:41 MST

Itzik covers solutions to the T-SQL challenge he provided last week.

Tue, 29 Sep 2009 04:00:41 MST

Itzik provides a T-SQL challenge where you need to write a query that returns a top row per partition.

Tue, 15 Sep 2009 04:00:41 MST

Itzik introduces his new book—Inside Microsoft SQL Server 2008: T-SQL Programming.

Sun, 30 Aug 2009 04:00:41 MST

Itzik discusses solutions to the T-SQL challenge from last week.