Category: T-SQL

Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the costs behind stream aggregates when the data needs to be sorted first.
Aaron Bertrand gives some scattered thoughts about how he has contributed to the SQL Server community throughout his career.
For his first post on SQLPerformance.com, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.
Two of our favorite Andys are gearing up for this weekend's #SQLSatMadison. Here Andy Yun talks about the event, the sessions that he will be presenting, and also talks about Andy Mallon's session.
April 4, 2018 | Andy Yun | SQLSaturday, T-SQL, PASS 0
Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.
March 29, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule.
March 13, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
Aaron Bertrand breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.
February 28, 2018 | Aaron Bertrand | Bad Habits, T-SQL, Best Practices 8
Lori Edwards, SentryOne Training Manager, writes about one of her favorite T-SQL rants in this T-SQL Tuesday #99 blog post.
February 13, 2018 | Lori Edwards | T-SQL, SQL Sentry, T-SQL Tuesday 0
In this T-SQL Tuesday post, Allen White shares his passion for performing, leading to his performance with the Cleveland Orchestra at Carnegie Hall.
February 13, 2018 | Allen White | T-SQL, SQL Sentry, T-SQL Tuesday 2
Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.
February 7, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
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

Top Categories

See all
1 2 3 4 5

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