Learn about the ORDER BY clause used to order query results set by one or more columns, including common use cases and performance considerations.
Category: T-SQL
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!
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.
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.
John Welch shares a script for checking MAXDOP, a SQL Server setting that controls how many processors may be used for parallel plan execution.
Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how NULLs are ordered.
Melissa Connors shares her perspective on Imposter Syndrome for T-SQL Tuesday #122.
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs, including the MERGE statement.
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
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.
Itzik Ben-Gan discusses lesser-known T-SQL features and some aspects that many of us make assumptions about.
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.
Itzik Ben-Gan continues a pitfall and best practices series with a post explaining how window functions can go wrong in SQL Server.
