Sometimes it’s hard to get people to understand the scale of a number without some commas.
I don’t know why that is, but that’s why I added the option to format numbers.
You can do that by running the procedure like so:
EXEC dbo.sp_QuickieStore @database_name = 'StackOverflow', @expert_mode = 1, @format_output = 1;
What you get back should look something like this.
This isn’t the most elegant screenshot in the world, I just want to give you an idea of what you should see.
Essentially, if it’s a number, it will get commas inserted into the proper places.
I know that this is a somewhat Americanized version of things, and that the FORMAT function supports other language stuff.
If that’s something you care about and you’d like to contribute, head over here. Code contributions are always welcome.
Tomorrow, we’ll look at options you have to get help, and troubleshoot code and performance issues.
Thanks for reading!
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
- SQL Server Community Tools: The Wrap Up And Combined Link
- SQL Server Community Tools: How To Dig Deeper With Expert Mode With sp_QuickieStore
- SQL Server Community Tools: Formatting sp_QuickieStore Output So It’s Easier To Understand
- SQL Server Community Tools: How To Find Specific Queries With sp_QuickieStore