June 29, 2009
Itzik provides a logic puzzle involving finding a substitute for dice.
June 6, 2009
Itzik responds to a reader comment about the article “Set-Based vs. Cursor-Based Solutions for Running Aggregates.”
May 31, 2009
Itzik describes a tip regarding working with cursor variables in the local batch.
May 28, 2009
Itzik demonstrates how you can optimize queries that use both regular aggregates and ones with DISTINCT.
April 30, 2009
Itzik demonstrates causes that prevent caching of temporary objects across invocations of a routine.
April 27, 2009
Itzik provides a tip to help you identify plans in cache.
March 29, 2009
Itzik describes findings of Will Alber concerning the article Optimizing a Suboptimal Query Plan.
March 24, 2009
Itzik introduces his new book – Inside Microsoft SQL Server 2008: T-SQL Querying.
February 28, 2009
Itzik describes a puzzle involving sums of values.
February 27, 2009
Itzik addresses a reader request to calculate the difference in terms of months between two dates.
January 30, 2009
Itzik provides a solution to the T-SQL challenge to write a custom sequence generator that is based on a single statement.
January 26, 2009
Itzik provides a T-SQL challenge involving a custom sequence generator.
December 30, 2008
Itzik talks about his previous New Year’s resolution—quitting smoking.
December 19, 2008
Itzik explains how you can improve the performance of queries that use scalar user defined functions.
November 22, 2008
Itzik demonstrates a technique to extract only the time part from a DATETIME value.
November 3, 2008
Join a live chat with SQL Server Magazine’s authors Andy Kelly, Mike Otey and Itzik Ben-Gan.
October 29, 2008
Itzik explains how you can normalize or shorten HIERARCHYID values that became too long.
October 22, 2008
Itzik talks about his new T-SQL Fundamentals book that was just published.
September 9, 2008
Itzik provides solutions to last week’s T-SQL sorting challenge.
September 1, 2008
Itzik provides a T-SQL challenge involving sorting separated lists of values.
Add these Headlines to your Website