Skip to content

Justin Onstot

All Data, Big and Small

Author: justino

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

Just how big ARE those tables?

If you need to know the size of all your tables, here's a simple query to get you where you need to go:

justino Uncategorized Leave a comment May 26, 2017

Posts navigation

Newer posts

Search

© 2019 Justin Onstot. All Rights Reserved.

Website Powered by WordPress.com.
Cancel