Category : T-SQL - SentryOne Team Blog

Category: T-SQL

Slides and Scripts: Architectural Choices That Impact Performance of Microsoft SQL Server

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!

Using Plan Explorer with Entity Framework

Using Plan Explorer with Entity Framework

Jason Hall gives a technical walk-through of one of his favorite use cases for Plan Explorer : troubleshooting application and Entity Framework code.

T-SQL Tuesday #96: Folks Who Have Made a Difference

T-SQL Tuesday #96: Folks Who Have Made a Difference

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

Paul White : Trigram Wildcard Search in SQL Server

Paul White discusses the pros and cons of maintaining three-character substrings (trigrams) to speed up wildcard searches. Continue reading…

Andy Mallon : Multi-Statement TVFs in Dynamics CRM

Andy Mallon : Multi-Statement TVFs in Dynamics CRM

Andy Mallon (@AMtwo) walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.

T-SQL Tuesday #92 : Lessons Learned the Hard Way

T-SQL Tuesday #92 : Lessons Learned the Hard Way

For T-SQL Tuesday #92, Aaron Bertrand (@AaronBertrand) shows one trick he uses to prevent errant DML from running in production.

Slides and Scripts: Baltimore SQL Server User Group

Slides and Scripts: Baltimore SQL Server User Group

Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.

Paul White : Properly Persisted Computed Columns

Paul White : Properly Persisted Computed Columns

Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.

Paul White : UNION ALL Optimization

Paul White : UNION ALL Optimization

Paul White (@SQL_Kiwi) digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.

A new series on performance-related SQL Server myths

A new series on performance-related SQL Server myths

Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley (@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 zone.

T-SQL Tuesday #87 : Shiny New Toys

T-SQL Tuesday #87 : Shiny New Toys

For T-SQL Tuesday #87, Aaron Bertrand (@AaronBertrand) talks about two shiny new toys used for disassembling and reassembling strings: STRING_SPLIT() and STRING_AGG().

Follow-up #1 on leading wildcard seeks

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.