Most Recent Blog Posts

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
09/25/2011 - 11:48pm


Not terminating T-SQL statements with a semicolon is on a deprecation path....More
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
08/03/2011 - 11:47am

Solution to TSQL Table Truncation Challenge

Itzik provides the solution to last week’s table truncation challenge....More
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
07/07/2011 - 1:00pm

Solutions to TSQL Challenge – Reoccurring Visits

Itzik covers solutions to last week’s puzzle – Reoccurring Visits....More
06/29/2011 - 8:44am

TSQL Challenge – Reoccurring Visits

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More
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
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
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
04/29/2011 - 5:31pm

What's Your Laptop?

Itzik describes his favorite laptop; what’s your laptop?....More
outer banks at sunrise
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
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
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
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
What's Puzzled By T-SQL Blog?

T-SQL tips and logical puzzles from Itzik Ben-Gan.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×