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.
Category: T-SQL
The DATEADD function adds (or subtracts) a whole-number increment to a specified date value.
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!
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.
