SentryOne Team Blog (blogs.sentryone.com)

Category: T-SQL

SQLSaturday #724 – Madison, WI

SQLSaturday #724 – Madison, WI

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.

Rob Farley : Dealing with date and time instead of datetime

Rob Farley : Dealing with date and time instead of datetime

Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.

Rob Farley : When DISTINCT <> GROUP BY

Rob Farley : When DISTINCT <> GROUP BY

Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule.

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) 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.

Photo credit: badgreeb_records

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.

T-SQL Tuesday #99 – My favorite Aaron Bertrand (T-SQL) rant

T-SQL Tuesday #99 – My favorite Aaron Bertrand (T-SQL) rant

Lori Edwards, SentryOne Training Manager, writes about one of her favorite T-SQL rants in this T-SQL Tuesday #99 blog post.

T-SQL Tuesday #99 : Performing is my Passion

T-SQL Tuesday #99 : Performing is my Passion

In this month's T-SQL Tuesday post, Allen shares his passion for performing, leading to his performance in January with the Cleveland Orchestra at Carnegie Hall.

Q & A from our Parameter Sniffing webinar series

Q & A from our Parameter Sniffing webinar series

Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.

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.