Aaron Bertrand continues his Bad Habits series; in this installment, he discusses ten common cases of misplaced optimization.
Category: T-SQL (9)
Paul White talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of...
Aaron Bertrand continues his Bad Habits series, explaining why you should avoid helper functions and use joins against the catalog views instead.
Paul White looks at a couple of cases where - even though T-SQL is supposed to be a declarative language and any query that uses the...
Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, Aaron Bertrand provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
Erin Stellato of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.
Aaron Bertrand takes a closer look at some additional requirements for typically grouped concatenation queries in SQL Server.
Aaron Bertrand uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
Aaron Bertrand shows the safest and most efficient ways to perform grouped concatenation in SQL Server.
Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing
Paul White uses several examples to describe subquery cardinality estimate bug.
Aaron Bertrand provides links to his recent presentations (one with colleague Kevin Kline) at SQL Bits XII.
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
