SQL Magazine - Puzzled by T-SQL

Logic Puzzle � Dice Substitute

Mon, 29 Jun 2009 09:00:08 MST

Itzik provides a logic puzzle involving finding a substitute for dice.

Sat, 06 Jun 2009 09:00:08 MST

Itzik responds to a reader comment about the article "Set-Based vs. Cursor-Based Solutions for Running Aggregates."

Sun, 31 May 2009 09:00:08 MST

Itzik describes a tip regarding working with cursor variables in the local batch.

Thu, 28 May 2009 09:00:08 MST

Itzik demonstrates how you can optimize queries that use both regular aggregates and ones with DISTINCT.

Thu, 30 Apr 2009 09:00:08 MST

Itzik demonstrates causes that prevent caching of temporary objects across invocations of a routine.