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

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

Geekiest Sig Challenge

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

SQL Server Magazine

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

Tip: Index on Computed Column

Itzik provides a tip regarding indexes on computed columns.

SQL Server Magazine

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

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

Solutions to Logic Puzzle - Crossing a Desert

Itzik describes solutions to the logic puzzle “Crossing a Desert” he provided last week.

SQL Server Magazine

Logic Puzzle – Crossing a Desert

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

SQL Server Magazine

More about Calculating Concurrent Sessions

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

SQL Server Magazine

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

Virtual Auxiliary Table of Numbers

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

SQL Server Magazine

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

Solutions to T-SQL Challenge - Efficient Partitioned TOP

Itzik covers solutions to the T-SQL challenge he provided last week.

SQL Server Magazine

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

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

New Book – T-SQL Programming

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

SQL Server Magazine

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

Solutions to T-SQL Challenge - Duplicating Form Entries

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

SQL Server Magazine

T-SQL Challenge - Duplicating Form Entries

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

SQL Server Magazine

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