Most Recent Blog Posts

Oct 02, 2011

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

Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
Sep 25, 2011


Not terminating T-SQL statements with a semicolon is on a deprecation path....More
Aug 31, 2011

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
Aug 03, 2011

Solution to TSQL Table Truncation Challenge

Itzik provides the solution to last week’s table truncation challenge....More
Jul 29, 2011

TSQL Challenge - Table Truncation - 29 Jul 20115

Itzik provides a challenge to perform fast clearing of the data from a table that has an indexed view defined on it....More
Jul 07, 2011

Solutions to TSQL Challenge – Reoccurring Visits22

Itzik covers solutions to last week’s puzzle – Reoccurring Visits....More
Jun 29, 2011

TSQL Challenge – Reoccurring Visits9

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More
Jun 02, 2011

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
May 31, 2011

Bug or Feature: REPLACE Puzzle5

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

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
Apr 29, 2011

What's Your Laptop?5

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

Aggregates with an Outer Reference3

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
Mar 30, 2011

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

Itzik talks about enhancements in SQL Server 2012 that provide new metadata discovery capabilities....More
Mar 19, 2011

Solutions to Packing Date and Time Intervals Puzzle8

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
Feb 28, 2011

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

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