• subscribe
Search
Browse By: Author | Issue
Itzik Ben-Gan

Puzzled by T-SQL Blog

by Itzik Ben-Gan

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

Itzik describes new T-SQL scalar functions in SQL Server Denali CTP 3....Read the rest of entry >>
Posted @ 10/02/2011 5:03 AM By Itzik Ben-Gan
 

Semicolon

Not terminating T-SQL statements with a semicolon is on a deprecation path....Read the rest of entry >>
Posted @ 09/26/2011 12:48 AM By Itzik Ben-Gan
 

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....Read the rest of entry >>
Posted @ 08/31/2011 5:42 PM By Itzik Ben-Gan
 

Solution to TSQL Table Truncation Challenge

Itzik provides the solution to last week’s table truncation challenge....Read the rest of entry >>
Posted @ 08/03/2011 12:47 PM By Ben-Gan, Itzik
 

TSQL Challenge - Table Truncation

Itzik provides a challenge to perform fast clearing of the data from a table that has an indexed view defined on it....Read the rest of entry >>
Posted @ 07/29/2011 3:40 PM By
 

Solutions to TSQL Challenge – Reoccurring Visits

Itzik covers solutions to last week’s puzzle – Reoccurring Visits....Read the rest of entry >>
Posted @ 07/07/2011 2:00 PM By Itzik Ben-Gan
 

TSQL Challenge – Reoccurring Visits

Itzik provides a T-SQL challenge involving identifying reoccurring visits to a website....Read the rest of entry >>
Posted @ 06/29/2011 9:44 AM By Itzik Ben-Gan
 

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 Mauri....Read the rest of entry >>
Posted @ 06/02/2011 10:29 AM By Itzik Ben-Gan
 

Bug or Feature: REPLACE Puzzle

Itzik discusses certain behavior of the REPLACE function that might seem like a bug to some....Read the rest of entry >>
Posted @ 05/31/2011 11:23 AM By Itzik Ben-Gan
 

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 Functions....Read the rest of entry >>
Posted @ 05/23/2011 1:12 PM By Itzik Ben-Gan
 

© 2012 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.