Category: T-SQL

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.
Kevin Kline shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Aaron Bertrand shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server Query.
October 8, 2015 | SQLPerformance.com | T-SQL 0
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
September 26, 2015 | Aaron Bertrand | SQLSaturday, T-SQL, Community 0
Aaron adds a few tidbits to follow up on his popular post on cursor options.
September 22, 2015 | SQLPerformance.com | T-SQL 0
Aaron Bertrand discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.
August 7, 2015 | Aaron Bertrand | T-SQL 3
Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements fro
August 6, 2015 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White takes one more look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.

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