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
|
370 results found for Itzik Ben-Gan, displaying items 1 - 20
|
 |
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
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
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
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
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
SQL Server Magazine
Table Variable Name as Column Prefix
Itzik provides a tip regarding using table variable names as column prefixes.
SQL Server Magazine
Using Nested Iterations and the OVER Clause for Running Aggregates
Until SQL Server supports the OVER clause, your best solutions for running aggregates are
a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.
SQL Server Magazine
Solutions to Logic Puzzle - Dice Substitute
Itzik covers solutions to last week’s logic puzzle – Dice Substitute.
SQL Server Magazine
Logic Puzzle – Dice Substitute
Itzik provides a logic puzzle involving finding a substitute for dice.
SQL Server Magazine
CLR-Based Solution for Running Aggregates
If performance is your main goal, you should use the set-based solution only with very small partition sizes; otherwise, you should use the CLR-based solution.
SQL Server Magazine
Ordered UPDATE and Set-Based Solutions to Running Aggregates
Itzik responds to a reader comment about the article “Set-Based vs. Cursor-Based Solutions for Running Aggregates.”
SQL Server Magazine
Tip Regarding Cursor Variables
Itzik describes a tip regarding working with cursor variables in the local batch.
SQL Server Magazine
Optimizing Aggregates with DISTINCT
Itzik demonstrates how you can optimize queries that use both regular aggregates and ones with DISTINCT.
SQL Server Magazine
Set-Based vs. Cursor-Based Solutions for Running Aggregates
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.
SQL Server Magazine
|
|
Register
