Tag : Bad Habits - 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

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.