Category: Best Practices

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
Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.
February 13, 2018 | Andy Yun | Best Practices, SQL Server, T-SQL Tuesday 0
MS MVP Kevin Kline walks through two ways to prepare for a peaceful and uninterrupted holiday: technology and process.
Get an overview of HIPAA regulations along with compliance tips and best practices from a healthcare legal specialist from the point of view of the DBA.
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Think of this series as a brain dump for all of the career advice we'd give to an aspiring DBA. Register now!
March 14, 2016 | Kevin Kline | Best Practices, SQL Server, Career 0
Stronger Security Via Always Encrypted in SQL Server 2016.
The Top 10 Mistakes Made by SQL Server DBAs
Aaron Bertrand continues his series on bad habits and best practices, this time focusing on the benefits of referencing columns in a query.
Aaron Bertrand treats a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.

Top Categories

See all

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