Category: T-SQL (4)

Want to download the slide deck and T-SQL scripts for the presentation Architecture Choices that Impact Performance of Microsoft SQL Server? Get them here!
December 6, 2017 | Kevin Kline | Performance, T-SQL, Community, Slide Decks 1
Lori Edwards shares about "Folks Who Have Made a Difference" in this T-SQL Tuesday blog post.
Paul White : Trigram Wildcard Search in SQL Server
September 8, 2017 | SQLPerformance.com | Execution Plans, T-SQL 0
Andy Mallon walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.
August 22, 2017 | SQLPerformance.com | T-SQL 0
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 | 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.

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