SentryOne Team Blog (

Tag : Bad Habits

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) 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.

Photo credit: badgreeb_records

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

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.

Best Practices : Properly referencing columns

Aaron Bertrand (@AaronBertrand) continues his series on bad habits and best practices, this time focusing on the benefits of referencing columns in a query.

Should I use NOLOCK against #temp tables?

Aaron Bertrand (@AaronBertrand) addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.

Bad habits : Clinging to old compatibility levels

Aaron Bertrand (@AaronBertrand discusses a common scenario: behavior is different between two SQL Server databases that may be the same version but have different compatibility levels.

Bad habits : Putting NOLOCK everywhere

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.

Aaron Bertrand : Stop making SQL Server do your dirty work

Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.

Bad habits : Looking for optimizations in all the wrong places

Aaron Bertrand (@AaronBertrand) continues his "bad habits" series; in this installment, he discusses ten common cases of misplaced optimization.

Presentations from SQL Bits XII : T-SQL Bad Habits & Best Practices

Aaron Bertrand (@AaronBertrand) provides links to his recent presentations (one with colleague Kevin Kline (@kekline)) at SQL Bits XII in Telford, UK.