How do you know this is all whitespace? The log is reused and should be rewritten over time. There is a circular nature to this, with SQL Server writing through...

It should not be growing every day with log backups unless you have an increasing workload. I suspect you're missing something. Perhaps your log backup are not running as you...

That is weird. I assume you moved to numeric/decimal? Or something else?

Any other numbers that you found to be a problem? I could likely script this, but it's an interesting...

Is the growth linear, or is it all of a sudden one day?

Glad you know what you're doing, and certainly I've made...

And while you're doing your Career Planning, don't forget about Retirement Planning.  It may not mean much to you when you're in your 20's and 30's, but it'll mean...

Very well said Steve!  Without a little "comparing" it is sometimes hard to push yourself.  You are one of the people that I've looked up to and used as...

Congrats

I work for a British company. We've had developers in AUS work for us

Thanks, I thought so, but wanted to be sure newer people to the platform are aware of this.

Should not, as a proc is not in SQLCMD mode. What is happening here in a script is SSMS in interpreting this a certain way.

You can call a proc here,...

I think that's the key, we're the same team, and we have to support, help, and learn from each other.

OK, I played around with this. I think your quotes are the problem. This works for me:

:setvar DirectoryRootPath "C:\Users\Steve\OneDrive\Documents\SQL\StoredProcedureRunTrackerID.txt"

--:!!if exist C:\Users\Steve\OneDrive\Documents\SQL\StoredProcedureRunTrackerID.txt  del C:\Users\Steve\OneDrive\Documents\SQL\StoredProcedureRunTrackerID.txt
!!if exist $(DirectoryRootPath) del...

As to pay cuts, I took a pay cut to work for SQLServerCentral. At the time, Andy, Brian and I were thinking to sell or do something because the site...

I agree with Lynn. What I'd add is you want your resume to stand out a bit. I try to make mine focus on (top to bottom)

• What I want...