Category: T-SQL

For T-SQL Tuesday #92, Aaron Bertrand (@AaronBertrand) shows one trick he uses to prevent errant DML from running in production.
July 11, 2017 | Aaron Bertrand | SSMS, T-SQL, T-SQL Tuesday 7
This week John Martin and I are representing SentryOne at SQLGrillen in Lingen, Germany. Here are my slides and samples.
June 2, 2017 | Aaron Bertrand | T-SQL, Community 0
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries...
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.
Kevin Kline provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of SQL Server trace flags.
Guest author Derik Hammer dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Aaron Bertrand begins a new series aimed at debunking common myths about SQL Server performance.
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time...
February 14, 2017 | | T-SQL, T-SQL Tuesday 0
Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
February 8, 2017 | | Triggers, T-SQL, Wildcard 0
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
January 26, 2017 | | T-SQL 0
Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
January 6, 2017 | | T-SQL, SQL Server 2017 0
Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
December 28, 2016 | | T-SQL, SQL Server 2017 0
After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.
November 9, 2016 | | T-SQL 0

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