Category: T-SQL (9)

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
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.
September 4, 2014 | Aaron Bertrand | Bad Habits, T-SQL 0
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.
August 29, 2014 | Aaron Bertrand | T-SQL 0
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.
August 20, 2014 | | T-SQL 0
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.
August 12, 2014 | Aaron Bertrand | SQLFamily, T-SQL 1
Aaron Bertrand shows the safest and most efficient ways to perform grouped concatenation in SQL Server.
August 6, 2014 | | T-SQL 0
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.
June 12, 2014 | | T-SQL, SQL Server 0

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