Most Recent Blog Posts

Oct. 2, 2011

Denali T-SQL at a Glance: New and Enhanced Functions

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

Semicolon

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 Denali CTP3

Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3....More
Aug. 3, 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 2011

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

Solutions to TSQL Challenge – Reoccurring Visits

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

TSQL Challenge – Reoccurring Visits

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....More
Jun. 2, 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 Puzzle

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?

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

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

Denali T-SQL at a Glance - Metadata Discovery

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

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

Denali 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