Skip to content

Justin Onstot

All Data, Big and Small

Category: SQL

JOIN versus WHERE filtering

Intellectually I knew that query results can vary depending on where we decide to "filter" our data. In the JOIN condition, or in the predicate WHERE clause? The following example of this revealed itself recently. It struck me as such a simple and clear case I thought others might benefit from it. The situation arose … Continue reading JOIN versus WHERE filtering →

justino SQL Leave a comment April 4, 2018April 4, 2018

Get rid of blank lines in SSMS

I often copy paste the output of "sp_helptext" for some of our stored procedures. For whatever reason, they often paste with numerous blank lines between each meaningful section of code. Here is how I get rid of those lines:

justino DBA, SQL Leave a comment May 26, 2017

Search

© 2019 Justin Onstot. All Rights Reserved.

Website Powered by WordPress.com.
Cancel