l T-SQL - Blog Category - SentryOne Blog

Category: T-SQL

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 | SQLPerformance.com | 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 | SQLPerformance.com | 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 | SQLPerformance.com | T-SQL 0
Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
January 6, 2017 | SQLPerformance.com | 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 | SQLPerformance.com | T-SQL, SQL Server 2017 0

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

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial