Plan Explorer Archives - SQLPerformance.com

Split strings the right way – or the next best way

Aaron Bertrand (@AaronBertrand) explores some common approaches people use to split strings, complete with performance analysis.

Aaron Bertrand ◆ September 2, 2021

25

Visualizing the Tipping Point with Plan Explorer

Greg Gonzalez shows off some new functionality in SentryOne Plan Explorer that literally visualizes the tipping point overlaying the histogram.

Greg Gonzalez ◆ May 7, 2020

4

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

Aaron Bertrand ◆ March 17, 2017

16

Plan Explorer 3.0 Webinar – Samples and Q & A

Aaron Bertrand (@AaronBertrand) follows up a recent webinar on Plan Explorer 3.0 with answers to about two dozen audience questions.

Aaron Bertrand ◆ September 15, 2016

0

Performance Testing Methodologies: Discovering a New Way

Erin Stellato (@erinstellato) of SQLskills talks about her performance testing methodologies and how she automates as much of this work as possible.

Erin Stellato ◆ March 11, 2014

2

An updated Plan Explorer demo kit

Aaron Bertrand (@AaronBertrand) walks through an updated demo kit for SentryOne Plan Explorer.

Aaron Bertrand ◆ March 5, 2014

2

Obfuscate sensitive data in your execution plans

Getting help with execution plans outside of your company can be a challenge, since you may not be willing to share information such as server names, database names, object names, schema, column names, index structure, and so on. Read on to see how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.

Aaron Bertrand ◆ March 1, 2013

2

Beware misleading data from SET STATISTICS IO

My co-worker Steve Wright (blog | @SQL_Steve) prodded me with a question recently on a strange result he was seeing. In order to test some functionality in our latest tool, SQL Sentry Plan Explorer PRO, he had manufactured a wide and large table, and was running a variety of queries against it. In one case he was returning a lot of data, but STATISTICS IO was showing that very few reads were taking place.

Aaron Bertrand ◆ October 30, 2012

11

Conditional Order By

A common scenario in many client-server applications is allowing the end user to dictate the sort order of results. Some people want to see the lowest priced items first, some want to see the newest items first, and some want to see them alphabetically. This is a complex thing to achieve in Transact-SQL because you can't just throw @SortColumn and @SortDirection into a straight T-SQL query.

Aaron Bertrand ◆ August 8, 2012

17

When the DRY principle doesn't apply : BITWISE operations in SQL Server

The "Don't Repeat Yourself" principle suggests that you should reduce repetition. This week I came across a case where DRY should be thrown out the window. There are other cases as well (for example, scalar functions), but this one was an interesting one involving Bitwise logic.

Aaron Bertrand ◆ August 1, 2012

11

Best approaches for running totals – updated for SQL Server 2012

Usually, changing a cursor to a set-based operation is sound advice, but there are some exceptions, like the one described here (running totals).

Aaron Bertrand ◆ July 24, 2012

33