l T-SQL - Blog Category - SentryOne Blog

Category: T-SQL

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
January 9, 2019 | SQLPerformance.com | T-SQL 0
Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
December 27, 2018 | SQLPerformance.com | T-SQL, SQL Server, UDFs 0
Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.
December 12, 2018 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
November 14, 2018 | SQLPerformance.com | T-SQL, Transaction Log 0
Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.
October 10, 2018 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.
September 12, 2018 | SQLPerformance.com | T-SQL 0
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.
September 11, 2018 | Aaron Bertrand | Triggers, T-SQL, T-SQL Tuesday 0
In the conclusion of his series on grouping and aggregation costs, Itzik Ben-Gan reveals some of the math behind seek vs. scan decisions.
In the fourth installment of his series on optimization thresholds, Itzik Ben-Gan looks at how SQL Server applies costs to parallel operations.
For this month's T-SQL Tuesday, Aaron Bertrand talks about his methods for metadata discovery in new versions of SQL Server.
July 10, 2018 | Aaron Bertrand | T-SQL, T-SQL Tuesday 0

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial