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
|
357 results found for Itzik Ben-Gan, displaying items 1 - 20
|
 |
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
Caching of Temporary Objects
Itzik demonstrates causes that prevent caching of temporary objects across invocations of a routine.
SQL Server Magazine
Tip Regarding Cached Plans
Itzik provides a tip to help you identify plans in cache.
SQL Server Magazine
Subqueries and Joins for Running Aggregates
Windows IT Pro
Subqueries and Joins for Running Aggregates
Both the subquery and join solutions perform reasonably well for calculating running aggregates when you have very small partitions, but the join approach is best for calculating multiple aggregates.
SQL Server Magazine
Optimization and Caching
Itzik describes findings of Will Alber concerning the article Optimizing a Suboptimal Query Plan.
SQL Server Magazine
New Book – Inside Microsoft SQL Server 2008: T-SQL Querying
Itzik introduces his new book – Inside Microsoft SQL Server 2008: T-SQL Querying.
SQL Server Magazine
More SQL Server 2008 T-SQL Improvements
Itzik discusses four enhancements, including composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more reliable object dependency information.
SQL Server Magazine
Sums Puzzle
Itzik describes a puzzle involving sums of values.
SQL Server Magazine
Calculating Month Difference
Itzik addresses a reader request to calculate the difference in terms of months between two dates.
SQL Server Magazine
SQL Server 2008’s T-SQL Features
SQL Server 2008 provides several small T-SQL features, such as an enhanced VALUES clause, improved ISO week number calculation, and the ability to convert character to binary and binary to character values while preserving the hexadecimal digits.
SQL Server Magazine
T-SQL Puzzle Solution – Custom Sequence
Itzik provides a solution to the T-SQL challenge to write a custom sequence generator that is based on a single statement.
SQL Server Magazine
T-SQL Puzzle – Custom Sequence
Itzik provides a T-SQL challenge involving a custom sequence generator.
SQL Server Magazine
More Options for Handling Arrays as Inputs
Use a Common Language Runtime (CLR) split user-defined function (UDF) or SQL Server 2008’s new table-valued parameters to handle arrays as inputs.
SQL Server Magazine
|
|
Register
