I might break this into two parts to get started. 1) jobs that are finished, 2) jobs that are not.

You could create a couple CTEs that would solve...

This is the same as a file copy. How would you copy a file from Server A to Server B?

You want security. Even if this is your music...

You'll need to group by dates as well, since 1400 occurs on multiple days. If you group by the hour, you'll combine the counts from Monday and Tuesday

To be clear, I don't like NULL for string columns. Often I think we can better describe this as N/A, Unknown, Unassigned, etc. For numbers, it makes some sense, as...

I think it's there now (speed and flexibility over cost), but what we're catching up with is trying to compare some performance on-premises to a cloud. In many cases people...

That's amazing. Didn't realize the text() had that impact. Any idea why?

It could be, but I also have used these in places where we weren't sure of the domain model for an entity. The business is a little flaky, and they...

What is the CLR procedure doing? Can you post the code and namespaces being used?

:), opinions do vary.

I really dislike EAVs, though they do have a very limited place at times. Perhaps someone feels differently and really likes them. Or they...

I think the CA does have some better limits. We'll see how it goes.

I didn't know how to showcase the space in there well. Maybe I need to add a note that the parameter is comma, space?

Ah, ticked the wrong checkbox on my side. My apologies. Awarding back points.