Category: T-SQL

Jason Hall adds to his series on mining performance data from the SQL Sentry database, this time showing how to get information about disks.
Aaron Bertrand discusses a handful of reasons "identical" query...
November 20, 2014 | SQLPerformance.com | Execution Plans, T-SQL 0
Jason Hall continues his series aiming to help you derive additional information by mining performance data from the SQL Sentry database.
November 10, 2014 | Jason Hall | T-SQL, Data Mining, Performance Analysis 0
Jason Hall starts a series of posts to help you derive additional information by mining performance data from the SQL Sentry database.
Aaron Bertrand repeats "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
October 22, 2014 | Aaron Bertrand | T-SQL 0
Paul White demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual...
October 2, 2014 | SQLPerformance.com | Execution Plans, T-SQL 0
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.
September 24, 2014 | Aaron Bertrand | Bad Habits, T-SQL 26
Jason Hall shows us how table variables have changed in SQL Server 2014 and reminds us how helpful it can be to follow up on hard questions.
September 18, 2014 | Jason Hall | T-SQL, SQL Server, Indexes, Table Variables 4
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.

Top Categories

See all
5 6 7 8 9

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More