Category: T-SQL

Melissa Connors shares her perspective on Imposter Syndrome for T-SQL Tuesday #122.
January 14, 2020 | Melissa Connors | T-SQL, T-SQL Tuesday 1
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs, including the MERGE statement.
January 8, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
December 11, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Jason Hall shares how the CHOOSE function in T-SQL is a game changer. Learn more to see if T-SQL CHOOSE() might help you with your own projects.
November 25, 2019 | Jason Hall | T-SQL, SQL Server 2012 3
Itzik Ben-Gan discusses lesser-known T-SQL features and some aspects that many of us make assumptions about.
October 10, 2019 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan adds another post to his series on T-SQL pitfalls and best practices series, treating complications and limitations of the PIVOT and UNPIVOT operators.
September 12, 2019 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan continues a pitfall and best practices series with a post explaining how window functions can go wrong in SQL Server.
August 14, 2019 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
April 13, 2019 | Aaron Bertrand | T-SQL, CodeStock, SQL Server 0
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

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