Category: T-SQL (5)

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
Aaron Bertrand explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.
November 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 7
Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.
October 17, 2016 | | Execution Plans, T-SQL 0
Aaron Bertrand explains why he codes defensively - matching the case of data type names, even when it isn't strictly necessary.
October 4, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 0
Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.
September 27, 2016 | | Execution Plans, T-SQL 0
Aaron Bertrand talks about pattern matching, a childhood game called Simon, and the unpredictability of CHARINDEX vs. LIKE.
September 6, 2016 | | T-SQL 0
Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.
Melissa Connors discusses locating & resolving SQL Server database trust issues (check constraints & foreign keys).
Aaron Bertrand continues his #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
Today I presented at Discovery Day New England, a SQL Server 2016 event (sponsored in part by SQL Sentry) held at the Microsoft office in Cambridge, MA. Attached are demos and slide decks.

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