Category: T-SQL

As a follow-up to my introduction to SQL Server joins, in this T-SQL tutorial, I’m going to take a closer look at the most used type of joins in SQL Server – the INNER JOIN.
September 20, 2022 | Paul S. Randal | T-SQL, SQL Sentry, Best Practices 0
The DATEADD function adds (or subtracts) a whole-number increment to a specified date value.
July 26, 2022 | Paul S. Randal | T-SQL 0
Learn how SQL JOIN is used to specify how to return data from different tables and the different SQL JOIN types in this comprehensive guide with examples.
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

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