Itzik Ben-Gan

Latest from Itzik Ben-Gan

Code
SQL Server
The Challenge Is on: Maintain a Custom Letter-Based SequenceThe Challenge Is on: Maintain a Custom Letter-Based Sequence
byItzik Ben-Gan
Apr 1, 2018
13 Min Read
Code snippet
SQL Server
The Challenge Is on: Multi-Way Number Partitioning with T-SQL and SQL CLRThe Challenge Is on: Multi-Way Number Partitioning with T-SQL and SQL CLR
byItzik Ben-Gan
Feb 21, 2018
20 Min Read

All from Itzik Ben-Gan

sort with descending order
Windows Server
SQL Server: Avoiding a Sort with Descending Order
SQL Server: Avoiding a Sort with Descending Order
Jan 19, 2018
|
16 Min Read
byItzik Ben-Gan
Order data with NULLs last, with Merge Join (Concatenation)
SQL Server
SQL Server: Avoiding a Sort with Merge Join Concatenation
SQL Server: Avoiding a Sort with Merge Join Concatenation
Dec 18, 2017
|
13 Min Read
byItzik Ben-Gan
Grouping connected items SQL Server
SQL Server
T-SQL Puzzle Challenge: Grouping Connected Items
T-SQL Puzzle Challenge: Grouping Connected Items
Nov 27, 2017
|
19 Min Read
byItzik Ben-Gan
ITPro Today logo
SQL Server
Graph Matching with T-SQL Part 3: Maximum Matching
Graph Matching with T-SQL Part 3: Maximum Matching
Oct 12, 2017
|
19 Min Read
byItzik Ben-Gan
ITPro Today logo
SQL Server
Graph Matching with T-SQL Part 2: Maximal Matching
Graph Matching with T-SQL Part 2: Maximal Matching
Sep 18, 2017
|
22 Min Read
byItzik Ben-Gan
ITPro Today logo
DevOps
Puzzle Challenge: Graph Matching with T-SQL Part 1-Concepts
Puzzle Challenge: Graph Matching with T-SQL Part 1-Concepts
Aug 8, 2017
|
17 Min Read
byItzik Ben-Gan
T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition
Other Programming Languages
T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition
T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition
Jul 11, 2017
|
12 Min Read
byItzik Ben-Gan
What You Need to Know about Distinct Windowed Aggregate Calculations
Innovations of the 2010s (SQL Server 2012 – 2019)
What You Need to Know about Distinct Windowed Aggregate Calculations
What You Need to Know about Distinct Windowed Aggregate Calculations
Jun 6, 2017
|
21 Min Read
byItzik Ben-Gan
What You Need to Know about Adaptive Joins over Rowstore
SQL Server
What You Need to Know about Adaptive Joins over Rowstore
What You Need to Know about Adaptive Joins over Rowstore
May 9, 2017
|
15 Min Read
byItzik Ben-Gan
Ordered Set Functions: What's New--and Missing--in SQL Server vNext
SQL Server
Ordered Set Functions: What's New--and Missing--in SQL Server vNext
Ordered Set Functions: What's New--and Missing--in SQL Server vNext
Apr 13, 2017
|
10 Min Read
byItzik Ben-Gan
How to Compute Date and Time Difference in Parts
SQL Server
How to Compute Date and Time Difference in Parts
How to Compute Date and Time Difference in Parts
Mar 15, 2017
|
9 Min Read
byItzik Ben-Gan
Identifying Existence of Intersections in Intervals
SQL Server
Identifying Existence of Intersections in Intervals
Identifying Existence of Intersections in Intervals
Feb 8, 2017
|
15 Min Read
byItzik Ben-Gan
Tips Concerning Temporal Tables
SQL Server
Tips Concerning Temporal Tables
Tips Concerning Temporal Tables
Jan 17, 2017
|
15 Min Read
byItzik Ben-Gan
What You Need to Know about DATETIMEOFFSET and SQL Server 2016's AT TIME ZONE Function
Innovations of the 2010s (SQL Server 2012 – 2019)
What You Need to Know about DATETIMEOFFSET and SQL Server 2016's AT TIME ZONE Function
What You Need to Know about DATETIMEOFFSET and SQL Server 2016's AT TIME ZONE Function
Dec 13, 2016
|
13 Min Read
byItzik Ben-Gan
Logical Query Processing Part 8 : SELECT and ORDER BY
SQL Server
Logical Query Processing Part 8 : SELECT and ORDER BY
Logical Query Processing Part 8 : SELECT and ORDER BY
Nov 15, 2016
|
18 Min Read
byItzik Ben-Gan
Logical Query Processing Part 7: GROUP BY and HAVING
Early Versions (SQL Server 2000 – 2008)
Logical Query Processing Part 7: GROUP BY and HAVING
Logical Query Processing Part 7: GROUP BY and HAVING
Oct 13, 2016
|
23 Min Read
byItzik Ben-Gan
Logical Query Processing Part 6: The WHERE Clause
SQL Server
Logical Query Processing Part 6: The WHERE Clause
Logical Query Processing Part 6: The WHERE Clause
Sep 15, 2016
|
21 Min Read
byItzik Ben-Gan
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3
Innovations of the 2010s (SQL Server 2012 – 2019)
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3
Aug 10, 2016
|
22 Min Read
byItzik Ben-Gan
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 2
Innovations of the 2010s (SQL Server 2012 – 2019)
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 2
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 2
Jul 12, 2016
|
17 Min Read
byItzik Ben-Gan
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 1
Innovations of the 2010s (SQL Server 2012 – 2019)
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 1
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 1
May 31, 2016
|
19 Min Read
byItzik Ben-Gan
Logical Query Processing Part 5: The FROM Clause and UNPIVOT
SQL Server
Logical Query Processing Part 5: The FROM Clause and UNPIVOT
Logical Query Processing Part 5: The FROM Clause and UNPIVOT
May 11, 2016
|
12 Min Read
byItzik Ben-Gan
The FROM Clause and PIVOT
SQL Server
Logical Query Processing: The FROM Clause and PIVOT
Logical Query Processing: The FROM Clause and PIVOT
Apr 12, 2016
|
13 Min Read
byItzik Ben-Gan
Logical Query Processing: The FROM Clause and APPLY
SQL Server
Logical Query Processing: The FROM Clause and APPLY
Logical Query Processing: The FROM Clause and APPLY
Mar 1, 2016
|
15 Min Read
byItzik Ben-Gan
Logical Query Processing: The FROM Clause and Joins
SQL Server
Logical Query Processing: The FROM Clause and Joins
Logical Query Processing: The FROM Clause and Joins
Feb 11, 2016
|
17 Min Read
byItzik Ben-Gan
Logical Query Processing: What It Is And What It Means to You
SQL Server
Logical Query Processing: What It Is And What It Means to You
Logical Query Processing: What It Is And What It Means to You
Jan 15, 2016
|
11 Min Read
byItzik Ben-Gan
How To: Previous and Next with Condition
SQL Server
How To: Previous and Next with Condition
How To: Previous and Next with Condition
Dec 10, 2015
|
13 Min Read
byItzik Ben-Gan
Packing Intervals with Priorities
SQL Server
Packing Intervals with Priorities
Packing Intervals with Priorities
Nov 10, 2015
|
27 Min Read
byItzik Ben-Gan
SQL Server Query Optimization: No Unknown Unknowns
Ops and More
SQL Server Query Optimization: No Unknown Unknowns
SQL Server Query Optimization: No Unknown Unknowns
Oct 13, 2015
|
14 Min Read
byItzik Ben-Gan
Seek and You Shall Scan Part I: When the Optimizer Doesn't Optimize
SQL Server
Seek and You Shall Scan Part I: When the Optimizer Doesn't Optimize
Seek and You Shall Scan Part I: When the Optimizer Doesn't Optimize
Sep 14, 2015
|
15 Min Read
byItzik Ben-Gan
Seek and You Shall Scan Part II: Ascending Keys
SQL Server
Seek and You Shall Scan Part II: Ascending Keys
Seek and You Shall Scan Part II: Ascending Keys
Sep 14, 2015
|
13 Min Read
byItzik Ben-Gan
ITPro Today logo
SQL Server
New Solution to the Packing Intervals Problem
New Solution to the Packing Intervals Problem
Aug 11, 2015
|
13 Min Read
byItzik Ben-Gan
First Look at System-Versioned Temporal Tables-Part 2: Querying Data and Optimization Considerations
Innovations of the 2010s (SQL Server 2012 – 2019)
First Look at System-Versioned Temporal Tables-Part 2: Querying Data and Optimization Considerations
First Look at System-Versioned Temporal Tables-Part 2: Querying Data and Optimization Considerations
Jul 6, 2015
|
21 Min Read
byItzik Ben-Gan
First Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data
SQL Server
First Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data
First Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data
Jun 18, 2015
|
16 Min Read
byItzik Ben-Gan

Editor's Choice

businessman pressing agile button
Software Development Techniques
Reassessing Agile Software Development: Is It Dead or Can It Be Revived?
Reassessing Agile Software Development: Is It Dead or Can It Be Revived?

May 8, 2024

digital security padlock icon connected to numbers
Edge Computing
Cybersecurity Quiz 2024: Test Your IT Security Knowledge
Cybersecurity Quiz 2024: Test Your IT Security Knowledge

Feb 15, 2024

Bavarian Minister of the Interior Joachim Herrmann wears Hololens 2
IoT
What Is HoloLens? The Future of Microsoft AR Tech
What Is HoloLens? The Future of Microsoft AR Tech

Apr 9, 2024

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up