February 3, 2010
Itzik discusses why you cannot trust techniques that perform multi-row variable assignment with an ORDER BY clause.
February 1, 2010
Itzik provides his geeky sig and challenges you to come up with your own.
January 20, 2010
Itzik provides a tip regarding indexes on computed columns.
December 27, 2009
Itzik describes how to calculate the difference in terms of weeks between two dates in a language-dependent manner.
December 6, 2009
Itzik describes solutions to the logic puzzle “Crossing a Desert” he provided last week.
November 30, 2009
Itzik provides a logic puzzle involving crossing a desert with enough food supply.
November 24, 2009
Itzik provides a solution to calculating concurrent sessions, including interval information.
October 29, 2009
Itzik provides code to generate a virtual auxiliary table of numbers efficiently.
October 5, 2009
Itzik covers solutions to the T-SQL challenge he provided last week.
September 29, 2009
Itzik provides a T-SQL challenge where you need to write a query that returns a top row per partition.
September 15, 2009
Itzik introduces his new book—Inside Microsoft SQL Server 2008: T-SQL Programming.
August 30, 2009
Itzik discusses solutions to the T-SQL challenge from last week.
August 24, 2009
Itzik provides a T-SQL challenge involving duplicating form entries.
July 29, 2009
Itzik provides a tip regarding using table variable names as column prefixes.
July 6, 2009
Itzik covers solutions to last week’s logic puzzle – Dice Substitute.
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.
Add these Headlines to your Website