You haven't grouped by hour, but by time.

Please read the discussion and look at the answers, you need to group by hour.

Excellent. Looking forward to it.

Could we leave the politics out of this. Whether you like the EU Parliment, US Congress, reps, etc., that's not relevant to the idea of adhering to or dealing with...

Great point, Drew. In that case, you might want to build a calendar table of hours and join back. I might even want to do this from the start, since...

You can use the UPDATE() or COLUMNS_UPDATED() functions to check if the column has changed. Or use a query to compare inserted.customername with deleted.customername.

https://docs.microsoft.com/en-us/sql/t-sql/functions/columns-updated-transact-sql?view=sql-server-2017

Erikur has given you a start, but here's the thing. If you restore to Azure, and you go over there for DR, how do you get back? That can be...

It's something to think about, but it's also a tough topic. What do we cover? All types of objects? Server tuning v index tuning v query tuning? We've debated it,...

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?