March, 2010
MAX and MIN Aggregates Against Partitioned Tables
Itzik provides a workaround for an optimization shortcoming in SQL Server 2008 SP1 and SQL Server 2005 SP3, related to MAX and MIN aggregate calculations against a partitioned table.
SQL Server Magazine
|
February, 2010
Calculating Concurrent Sessions, Part 3
A new set-based solution, created by readers, is about an order of magnitude faster than Itzik’s previous set-based solution.
SQL Server Magazine
|
February, 2010
Multi-Row Variable Assignment and ORDER BY
Itzik discusses why you cannot trust techniques that perform multi-row variable assignment with an ORDER BY clause.
SQL Server Magazine
|
February, 2010
Geekiest Sig Challenge
Itzik provides his geeky sig and challenges you to come up with your own.
SQL Server Magazine
|
January, 2010
Handling the Tree Path Request
Learn why the intuitive queries that address a common tree path request are optimized inefficiently, and discover alternative solutions with improved performance.
SQL Server Magazine
|
January, 2010
Tip: Index on Computed Column
Itzik provides a tip regarding indexes on computed columns.
SQL Server Magazine
|
December, 2009
DATEDIFF with the Week Part
Itzik describes how to calculate the difference in terms of weeks between two dates in a language-dependent manner.
SQL Server Magazine
|
December, 2009
Properties of Relations on Sets
The author discusses a fundamental topic in mathematical set theory to determine the properties of a relation represented by a table called R on a set represented by a table called V.
SQL Server Magazine
|
December, 2009
Solutions to Logic Puzzle - Crossing a Desert
Itzik describes solutions to the logic puzzle “Crossing a Desert” he provided last week.
SQL Server Magazine
|
November, 2009
Logic Puzzle – Crossing a Desert
Itzik provides a logic puzzle involving crossing a desert with enough food supply.
SQL Server Magazine
|
November, 2009
More about Calculating Concurrent Sessions
Itzik provides a solution to calculating concurrent sessions, including interval information.
SQL Server Magazine
|
November, 2009
Calculating Concurrent Sessions, Part 2
Itzik presents a set-based solution with linear complexity that performs better than the previous solutions. He also discusses a set-based solution that will outperform all other solutions once SQL Server supports it.
SQL Server Magazine
|
October, 2009
Virtual Auxiliary Table of Numbers
Itzik provides code to generate a virtual auxiliary table of numbers efficiently.
SQL Server Magazine
|
October, 2009
Calculating Concurrent Sessions, Part 1
Itzik discusses a set-based and a cursor-based solution to a T-SQL concurrent sessions querying problem, as well as the performance and scaling ramifications of both solutions.
SQL Server Magazine
|
October, 2009
Solutions to T-SQL Challenge - Efficient Partitioned TOP
Itzik covers solutions to the T-SQL challenge he provided last week.
SQL Server Magazine
|
September, 2009
T-SQL Challenge – Efficient Partitioned TOP
Itzik provides a T-SQL challenge where you need to write a query that returns a top row per partition.
SQL Server Magazine
|
September, 2009
Beware the NOLOCK Hint
In this PASS Summit Unite 2009 Speaker Tip, T-SQL expert Itzik Ben-Gan describes how this hint can cause more harm than good when it comes to your storage engine's decision-making process.
SQL Server Magazine
|
September, 2009
New Book – T-SQL Programming
Itzik introduces his new book—Inside Microsoft SQL Server 2008: T-SQL Programming.
SQL Server Magazine
|
September, 2009
Date and Time Support in SQL Server 2008
Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
SQL Server Magazine
|
August, 2009
Solutions to T-SQL Challenge - Duplicating Form Entries
Itzik discusses solutions to the T-SQL challenge from last week.
SQL Server Magazine
|