This is what we came up with so far.

But it is not confirmed that I will have a list of ClaimNumbers to pre-populate like this...

/* --------------- D.A-...

Here is the query plan.

Jeff,

Re:  sp_ShowWorst

Question:  will collecting rows from SYSTEM DBs (i see a lot from msdb, master...)  be beneficial to me in any way?

i am thinking to easily  modify/limit it to user...

<<< https://www.sql.ru/forum/96127/sp-who3%5B/quote%5DMsg 8152, Level 16, State 13, Line 1

String or binary data would be truncated.

DBCC execution completed. If DBCC printed error messages, >>.   Jeff, what parameters did you call the...

// (possible exceptions may exist for non shared servers and for individuals that have functions like production support/application admin).

Yes: ), that's me !

Another solution I found

. This Module Signing looks a bit too involved, but allows very granular permissions for Stored Procedures without giving user higher privileges.

Module Signing is how you accomplish this. ...

And I most likely will not be given a View Server State of View Database State.  for any database on the server. Yet still need to run procs to collect...

Sure, found it, thank you. I know, my habit to laziness caused me to ask a simple question I should not have been asking... yet there is a variation of...

Thank you, Jeff, for your explanation, very helpful.

Question:

If we compile your SP  (and a couple of other SPs in which i access either system objects in MASTER db or Query...

And another important aspect:  should I use info from all 3 stores that is common and draw certain benefits from that or

look at what each of them has that the...

Thank you, Grant, for a very clear answer!

Continuing the subject, there is a tough question that has  been processing itself through me for quite a few months already.

How (exactly) can...

Definitely, Jeff, I will be honored if you attend my 12 noon EST meetup meeting. If you could say a few comments on your SP it would be delightful, too....

other than UNION all results and patch with fake columns ('' and zeros and other defaults and converting datatypes)

i do not see other / easier / quicker way .

But perhaps...

Also, please enjoy sp_Who3

https://www.sql.ru/forum/96127/sp-who3

Thank you, Jeff !

Studying your sp_ShowWorst today. Pretty amazing so far.

I will definitely share a couple of  SPs in same 'LOB' as your that I have written recently.

Starting to test...