Puzzled By T-SQL Blog

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

Itzik Ben-Gan — Sun, 02 Oct 2011 05:03:04 GMT

By Itzik Ben-Gan
Itzik describes new T-SQL scalar functions in SQL Server Denali CTP 3.

Semicolon

Itzik Ben-Gan — Mon, 26 Sep 2011 00:48:54 GMT

By Itzik Ben-Gan
Not terminating T-SQL statements with a semicolon is on a deprecation path.

Improved Support for Window Functions in SQL Server Denali CTP3

Itzik Ben-Gan — Wed, 31 Aug 2011 17:42:23 GMT

By Itzik Ben-Gan
Itzik describes the enhanced support for window functions introduced in Microsoft SQL Server Denali CTP3.

Solution to TSQL Table Truncation Challenge

Ben-Gan, Itzik — Wed, 03 Aug 2011 12:47:40 GMT

By Ben-Gan, Itzik
Itzik provides the solution to last week’s table truncation challenge.

TSQL Challenge - Table Truncation

Fri, 29 Jul 2011 15:40:20 GMT

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

Solutions to TSQL Challenge – Reoccurring Visits

Itzik Ben-Gan — Thu, 07 Jul 2011 14:00:00 GMT

By Itzik Ben-Gan
Itzik covers solutions to last week’s puzzle – Reoccurring Visits.

TSQL Challenge – Reoccurring Visits

Itzik Ben-Gan — Wed, 29 Jun 2011 09:44:57 GMT

By Itzik Ben-Gan
Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website.

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

Itzik Ben-Gan — Thu, 02 Jun 2011 10:29:00 GMT

By Itzik Ben-Gan
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 Mauri.

Bug or Feature: REPLACE Puzzle

Itzik Ben-Gan — Tue, 31 May 2011 11:23:00 GMT

By Itzik Ben-Gan
Itzik discusses certain behavior of the REPLACE function that might seem like a bug to some.

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

Itzik Ben-Gan — Mon, 23 May 2011 13:12:00 GMT

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