Itzik Ben-Gan

Contributing Editor, SQL Server Pro

Itzik Ben-Gan is a contributing editor to SQL Server Pro and a cofounder of SolidQ. He teaches, lectures, and consults internationally. He's a SQL Server MVP and is the author of several books about T-SQL, including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Microsoft Press).

Posts by Itzik Ben-Gan

in Puzzled By T-SQL Blog 04/29/2011 - 5:31pm

What's Your Laptop?

Itzik describes his favorite laptop; what’s your laptop?....More
outer banks at sunrise
in Puzzled By T-SQL Blog 04/27/2011 - 7:05am

Aggregates with an Outer Reference

Itzik talks about a restriction in T-SQL related to aggregate functions with an outer reference and provides a workaround....More
Discover enhancements in SQL Server 2012
in Puzzled By T-SQL Blog 03/30/2011 - 1:13pm

SQL Server 2012 T-SQL at a Glance - Metadata Discovery

Itzik talks about enhancements in SQL Server 2012 that provide new metadata discovery capabilities....More
in Puzzled By T-SQL Blog 03/19/2011 - 2:40am

Solutions to Packing Date and Time Intervals Puzzle

Itzik covers solutions to the Packing Date and Time Intervals puzzle, including a new solution that runs under 10 seconds with 5,000,000 rows....More
in Puzzled By T-SQL Blog 02/28/2011 - 7:28pm

SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS

Itzik describes a new T-SQL option in SQL Server Denali for the EXECUTE statement called RESULT SETS....More
man throwing javelin
in Puzzled By T-SQL Blog 02/23/2011 - 4:21pm

SQL Server 2012 T-SQL at a Glance – THROW

Itzik provides a preview of the new THROW command introduced in SQL Server 2012....More
in Puzzled By T-SQL Blog 01/27/2011 - 5:49pm

Clarifications Regarding TSQL Challenge: Packing Date and Time Intervals

Itzik provides a status update and clarifies a few points regarding the open T-SQL challenge involving packing date and time intervals....More
in Puzzled By T-SQL Blog 01/16/2011 - 4:36am

TSQL Challenge: Packing Date and Time Intervals

Test your T-SQL querying skills by trying to solve a fundamental problem in the relational model known as packing intervals....More
in Puzzled By T-SQL Blog 12/23/2010 - 3:18pm

Solutions to TSQL Challenge with Denali’s Sequence Object

Itzik covers solutions to the T-SQL challenge from last week involving Denali’s sequence object....More
in Puzzled By T-SQL Blog 12/15/2010 - 4:39pm

T-SQL Challenge with SQL Server 2012’s Sequence Object

Itzik provides a T-SQL challenge involving sequences in SQL Server 11, code-named Denali....More

Sponsored Introduction Continue on to (or wait seconds) ×