In this T-SQL Tuesday post, Allen White shares his passion for performing, leading to his performance with the Cleveland Orchestra at Carnegie Hall.
Category: T-SQL (4)
Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.
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!
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
Andy Mallon walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.
For T-SQL Tuesday #92, Aaron Bertrand (@AaronBertrand) shows one trick he uses to prevent errant DML from running in production.
This week John Martin and I are representing SentryOne at SQLGrillen in Lingen, Germany. Here are my slides and samples.
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...
