Itzik Ben-Gan
   


Itzik Ben-Gan is a mentor with Solid Quality Mentors. He teaches, lectures, and consults internationally. He’s a SQL Server MVP and is the author of several books about T-SQL, including Inside Microsoft SQL Server 2008: T-SQL Querying (Microsoft Press).
Email address: Itzik@SolidQ.com
Web site: http://www.SolidQualityLearning.com

379 results found for Itzik Ben-Gan, displaying items 1 - 20
February 3, 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 1, 2010

Geekiest Sig Challenge

Itzik provides his geeky sig and challenges you to come up with your own.

SQL Server Magazine

February 2010

Handling the Tree Path Request This article is only available to subscribers. Sign up now and get instant access!

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 20, 2010

Tip: Index on Computed Column

Itzik provides a tip regarding indexes on computed columns.

SQL Server Magazine

December 27, 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

January 2010

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 6, 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 30, 2009

Logic Puzzle – Crossing a Desert

Itzik provides a logic puzzle involving crossing a desert with enough food supply.

SQL Server Magazine

November 24, 2009

More about Calculating Concurrent Sessions

Itzik provides a solution to calculating concurrent sessions, including interval information.

SQL Server Magazine

December 2009

Calculating Concurrent Sessions, Part 2 This article is only available to subscribers. Sign up now and get instant access!

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 29, 2009

Virtual Auxiliary Table of Numbers

Itzik provides code to generate a virtual auxiliary table of numbers efficiently.

SQL Server Magazine

November 2009

Calculating Concurrent Sessions, Part 1 This article is only available to subscribers. Sign up now and get instant access!

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 5, 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 29, 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 21, 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 15, 2009

New Book – T-SQL Programming

Itzik introduces his new book—Inside Microsoft SQL Server 2008: T-SQL Programming.

SQL Server Magazine

October 2009

Date and Time Support in SQL Server 2008 This article is only available to subscribers. Sign up now and get instant access!

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 30, 2009

Solutions to T-SQL Challenge - Duplicating Form Entries

Itzik discusses solutions to the T-SQL challenge from last week.

SQL Server Magazine

August 24, 2009

T-SQL Challenge - Duplicating Form Entries

Itzik provides a T-SQL challenge involving duplicating form entries.

SQL Server Magazine

September 2009

Minimally Logged Inserts This article is only available to subscribers. Sign up now and get instant access!

Learn which insert methods can benefit from minimal logging, to improve your statements' performance.

SQL Server Magazine

Add these Headlines to your Website





     [1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   next page 




 

ADS BY GOOGLE