Puzzled By T-SQL Blog

Most Recent Blog Posts

by Itzik Ben-Gan 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

by Itzik Ben-Gan Sep. 25, 2011

Semicolon

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

by Itzik Ben-Gan 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

by Itzik Ben-Gan Aug. 3, 2011

Solution to TSQL Table Truncation Challenge

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

by Itzik Ben-Gan 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

by Itzik Ben-Gan Jul. 7, 2011

Solutions to TSQL Challenge – Reoccurring Visits

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

by Itzik Ben-Gan Jun. 29, 2011

TSQL Challenge – Reoccurring Visits

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

by Itzik Ben-Gan 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

by Itzik Ben-Gan 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

by Itzik Ben-Gan 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

by Itzik Ben-Gan Apr. 29, 2011

What's Your Laptop?

Itzik describes his favorite laptop; what’s your laptop?....More

by Itzik Ben-Gan 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

by Itzik Ben-Gan 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

by Itzik Ben-Gan 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

by Itzik Ben-Gan 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

Connect With Us