Category: Bad Habits

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
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 points out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.
Aaron Bertrand treats a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.
Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.
September 24, 2014 | Aaron Bertrand | Bad Habits, T-SQL 26
Aaron Bertrand discusses examples where people expect SQL Server to perform tasks that really should be performed outside the...
Aaron Bertrand continues his Bad Habits series; in this installment, he discusses ten common cases of misplaced optimization.
September 16, 2014 | Aaron Bertrand | Bad Habits, T-SQL 1
Aaron Bertrand continues his Bad Habits series, explaining why you should avoid helper functions and use joins against the catalog views instead.
September 4, 2014 | Aaron Bertrand | Bad Habits, T-SQL 0
Aaron Bertrand provides links to his recent presentations (one with colleague Kevin Kline) at SQL Bits XII.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More