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.
Category: Bad Habits
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.
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.
Aaron Bertrand continues his Bad Habits series, explaining why you should avoid helper functions and use joins against the catalog views instead.
Aaron Bertrand provides links to his recent presentations (one with colleague Kevin Kline) at SQL Bits XII.
