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

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


Not terminating T-SQL statements with a semicolon is on a deprecation path....More

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

Solution to TSQL Table Truncation Challenge

Itzik provides the solution to last week’s table truncation challenge....More

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

Solutions to TSQL Challenge – Reoccurring Visits

Itzik covers solutions to last week’s puzzle – Reoccurring Visits....More

TSQL Challenge – Reoccurring Visits

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More

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

Bug or Feature: REPLACE Puzzle

Itzik discusses certain behavior of the REPLACE function that might seem like a bug to some....More

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