Category: T-SQL

Learn about the ORDER BY clause used to order query results set by one or more columns, including common use cases and performance considerations.
SQL Server expert explains the T-SQL DISTINCT clause, including use cases, common performance considerations, tips, and tricks.
Learn about T-SQL UNION operator best practices from a respected SQL Server expert with examples and answers to questions like UNION vs. UNION ALL.
Jason Hall shares the loose process he followed to build a SentryOne database query that would return the growth of databases over time.
Have you ever wondered how many pancakes can fit into a mailbox? You're not alone!
May 14, 2020 | Jason Hall | T-SQL, Community 0
Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019.
March 17, 2020 | SQLPerformance.com | T-SQL, SQL Server 2019 0
Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.
March 11, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
John Welch shares a script for checking MAXDOP, a SQL Server setting that controls how many processors may be used for parallel plan execution.
February 18, 2020 | John Welch | Performance, T-SQL, SQL Server, MAXDOP 0
Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how NULLs are ordered.
February 12, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
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

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