Category: T-SQL (8)

Aaron Bertrand addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
February 26, 2015 | Aaron Bertrand | T-SQL 5
Aaron Bertrand talks about a couple of subtleties of SQL Server's THROW statement, and how to avoid frustrating bouts of troubleshooting.
February 13, 2015 | Aaron Bertrand | T-SQL 1
Paul White explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation or...
January 23, 2015 | | T-SQL 0
Aaron Bertrand shows how to use common table expressions...
January 12, 2015 | | T-SQL, SQL Server 2012 0
Aaron Bertrand walks through several potential causes for different plans for identical servers.
Lori Edwards reminds us about a couple of columns in sys.dm_exec_requests that can give us an idea about the progress of certain operations.
November 25, 2014 | Lori Edwards | T-SQL, Monitoring 0
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 | | 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 | | 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

Top Categories

See all
5 6 7 8 9

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