SentryOne Team Blog (blogs.sentryone.com)

Category: T-SQL

Paul Randal : Knee-Jerk Performance Tuning : Temp Tables

Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

#BackToBasics : Dating Responsibly

As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.

Paul White : Changes to a Writable Partition May Fail Unexpectedly

Paul White (@SQL_Kiwi) shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.

Performance Surprises and Assumptions : STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.

#BackToBasics : The Beauty of the Synonym

Aaron Bertrand (@AaronBertrand) continues his "Back to Basics" series, this time discussing SQL Server's synonym and how it can be used.

Performance Surprises and Assumptions : SET NOCOUNT ON

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.

#BackToBasics : The "Runaway" Query

Aaron Bertrand (@AaronBertrand) describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.

Comparing string splitting / concatenation methods

Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.

Subjectivity : Naming Standards

Aaron Bertrand (@AaronBertrand) discusses a few counterpoints to a very thorough and useful post on database naming standards.

How to Reduce Latency and Boost SQL Server Performance Webcast, Slides, and Scripts

Kevin Kline (@kekline) shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.

Maintaining a grouped running MAX (or MIN)

Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.

Slides and samples from SQL Saturday Holland

Aaron Bertrand (@AaronBertrand) shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance (#434, in Utrecht, Netherlands).

Aaron Bertrand : Follow-up on cursor options

Aaron (@AaronBertrand) adds a few tidbits to follow up on his popular post on default cursor options in SQL Server.

Bad Habits : Being CarELesS about cAsE

Aaron Bertrand (@AaronBertrand) discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.