Category: Best Practices

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.
This article gives a primer on restoring database backups, transaction log backups, and the correct restore sequence needed for a series of backups.
November 18, 2021 | Tim Radney | Best Practices, SQL Server, Backups 0
Learn some general recommendations for how to approach SQL Server performance tuning to maximize effort and minimize distractions.
October 6, 2021 | Paul S. Randal | Best Practices, SQL Server 0
Learn about SQL Server best practices for choosing storage options.
September 29, 2021 | Jonathan Kehayias | Best Practices, SQL Server, Storage 0
Nick Harshbarger discusses why you should avoid the blame game and instead define a process for responding pragmatically to critical situations.
Justin Kent shares considerations for designing software on the web versus native in 2020.
May 11, 2020 | Justin Kent | Best Practices, Migration 1
Tamika White shares tips that will empower you to make a positive contribution to your company while working remotely as a result of the COVID-19 pandemic.
Kevin Kline recaps a webinar with the SQLskills team, where they discussed their top SQL Server troubleshooting horror stories and the lessons learned.
In this blog, Kevin Kline shares the top 10 most common SQL Server mistakes made by DBAs, and resources to help avoid them.
January 22, 2020 | Kevin Kline | Best Practices, SQL Server 1
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
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
Aaron Bertrand breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.
February 28, 2018 | Aaron Bertrand | Bad Habits, T-SQL, Best Practices 8

Top Categories

See all
1 2

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