Dammit.  I know I typed up a long explanation this morning of what "WorkLoad" means and now it's gone.  Maybe I forgot to hit SUBMIT or something.  Whatever.  🙁  I...

On way is to use the following dynamic management view...

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views

The "best" way would be to sample the view for the current SPID (@@SPID) that will run the "batch" for the...

To answer the question that I think you're asking, do something like this just before you combine @Body and @XML.

SET @xml = REPLACE(@XML,'<tr>','<tr style="background-color:Red; color:White; ">')

If you...

This is going to depend a whole lot on what you mean by a "batch".  What do you mean by "batch" here?

Please don't mistake my answer as being "snarky"... I'm trying to help you help yourself in the future. 🙂

When you have a question like this, you have to ask yourself...

Unless you have a process that requires that successful backups be logged in the SQL Server Error Log, I'd turn those off.  Here's just one article on how to do...

Well now... that's pretty rude. 😉  The question you deleted may have helped others.

I'm starting to see this exact question a whole lot.  I'm starting to think that it's a prelude to spam. 🙁

To the best of my knowledge, the product keys for...

Excellent summary and examples - especially appreciated the animation showing how to navigate the interface!

As a practical note, I recommend not leaning too heavily on color to provide meaning...

Thanks everyone for sharing your inputs.

Sometimes we are seeing below patterns

"Application runs a query every 10 mins without any good reason."

There is a MERGE statement which does some data...

You've been around for a long time and I think I've shown you this before but one more time.

When you're filling out a post...

To add to what Johan posted, your worst performing queries will NOT usually be your longest running queries and it may not be the queries themselves, at all... it could...

Like a lot of the other answers on this thread, that's a lot of non-bullet-proof IF's that will eventually result in silent errors producing an incorrect answer.

Don't assume.  Yeah... you...

My question would be...

Why are you storing such a script on the root of the C: where some users could tamper with it or delete it?  This should be in...

I have a SQL 2012 database with simple recovery that backs up every night.  Normally the backup file is around 87,000 MB and grows proportionality as data is added. ...