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 10/02/2011 - 4:03am

SQL Server 2012 T-SQL at a Glance: New and Enhanced Functions

Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
in Puzzled By T-SQL Blog 09/25/2011 - 11:48pm

Semicolon

Not terminating T-SQL statements with a semicolon is on a deprecation path....More
in Puzzled By T-SQL Blog 08/31/2011 - 4:42pm

Improved Support for Window Functions in SQL Server 2012 CTP3

Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3....More
in Puzzled By T-SQL Blog 08/03/2011 - 11:47am

Solution to TSQL Table Truncation Challenge

Itzik provides the solution to last week’s table truncation challenge....More
in Puzzled By T-SQL Blog 07/29/2011 - 2:40pm

TSQL Challenge - Table Truncation - 29 Jul 2011

Itzik provides a challenge to perform fast clearing of the data from a table that has an indexed view defined on it....More
in Puzzled By T-SQL Blog 07/07/2011 - 1:00pm

Solutions to TSQL Challenge – Reoccurring Visits

Itzik covers solutions to last week’s puzzle – Reoccurring Visits....More
in Puzzled By T-SQL Blog 06/29/2011 - 8:44am

TSQL Challenge – Reoccurring Visits

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More
in Puzzled By T-SQL Blog 06/02/2011 - 9:29am

Free e-book on DQ and MDM by Sarka and Mauri

Download your free copy of a new e-book about Data Quality and Master Data Management for Microsoft SQL Server 2008 R2 by Dejan Sarka and Davide....More
in Puzzled By T-SQL Blog 05/31/2011 - 10:23am

Bug or Feature: REPLACE Puzzle

Itzik discusses certain behavior of the REPLACE function that might seem like a bug to some....More
in Puzzled By T-SQL Blog 05/23/2011 - 12:12pm

TechEd Atlanta 2011 - Materials for Session - Efficient T-SQL Querying using SQL Server Denali’s Window Functions

Itzik provides the materials for his TechEd Atlanta 2011 session; Code: DBI310; Topic: Efficient T-SQL Querying using SQL Server Denali’s Window....More

Sponsored Introduction Continue on to (or wait seconds) ×