Category: T-SQL

Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
April 10, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
March 29, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.
March 13, 2019 | SQLPerformance.com | T-SQL, Best Practices 0
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
February 13, 2019 | SQLPerformance.com | T-SQL 0
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
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
For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server.
June 18, 2018 | SQLPerformance.com | T-SQL 0

Top Categories

See all
1 2 3 4 5

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