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

What's Your Laptop?

Itzik describes his favorite laptop; what’s your laptop?....More
outer banks at sunrise

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

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

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

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

SQL Server 2012 T-SQL at a Glance – THROW

Itzik provides a preview of the new THROW command introduced in SQL Server 2012....More

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

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

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

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) ×