SentryOne Team Blog (blogs.sentryone.com)

Category : T-SQL

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.

Itzik Ben-Gan : Closest Match, Part 2

Itzik Ben-Gan : Closest Match, Part 2

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.

Itzik Ben-Gan : Closest Match, Part 1

Itzik Ben-Gan : Closest Match, Part 1

Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.

Itzik Ben-Gan : Understanding log buffer flushes

Itzik Ben-Gan : Understanding log buffer flushes

Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.

Itzik Ben-Gan : Reader solutions to Special Islands challenge

Itzik Ben-Gan : Reader solutions to Special Islands challenge

Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.

Itzik Ben-Gan : Special Islands

Itzik Ben-Gan : Special Islands

Itzik Ben-Gan explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.

T-SQL Tuesday #106 : INSTEAD OF triggers

T-SQL Tuesday #106 : INSTEAD OF triggers

For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.

Itzik Ben-Gan : Optimization Thresholds : Grouping and Aggregating Data, Part 5

Itzik Ben-Gan : Optimization Thresholds : Grouping and Aggregating Data, Part 5

In the conclusion of his series on grouping and aggregation costs, Itzik Ben-Gan reveals some of the math behind seek vs. scan decisions.

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 4

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 4

In the fourth installment of his series on optimization thresholds, Itzik Ben-Gan looks at how SQL Server applies costs to parallel operations.

T-SQL Tuesday #104 : Code I Would Hate to Live Without

T-SQL Tuesday #104 : Code I Would Hate to Live Without

For this month's T-SQL Tuesday, Aaron Bertrand talks about his methods for metadata discovery in new versions of SQL Server.

Bert Wagner : Join Elimination

Bert Wagner : Join Elimination

For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server.

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 3

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 3

Itzik Ben-Gan dissects the Hash Match (Aggregate) algorithm in his latest post in a series on SQL Server optimization thresholds.

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 2

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 2

Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the costs behind stream aggregates when the data needs to be sorted first.