Category: T-SQL

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, Transact-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.

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