Category: T-SQL (6)

Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand answers the question "Is a RID Lookup faster than a Key Lookup?" on the SQLPerformance.com blog.
Aaron Bertrand shows that, at least for a large number of...
Aaron Bertrand shares his slides and demos from his two SQL Intersection.
Aaron Bertrand follows up on a recent post about the performance...
Aaron Bertrand explores yet another scenario where a date/time...
Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary table
April 6, 2016 | SQLPerformance.com | T-SQL, tempdb 0
Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT.
Aaron Bertrand continues his Back to Basics series, this time discussing SQL Server's synonym and how it can be used.
March 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL, SQL Server 10
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE
February 26, 2016 | SQLPerformance.com | T-SQL 0
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
Aaron Bertrand compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.
January 22, 2016 | SQLPerformance.com | T-SQL 0
Aaron Bertrand discusses a few counterpoints to a very thorough and useful post on database naming standards.
January 18, 2016 | Aaron Bertrand | T-SQL 45
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.

Top Categories

See all

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