Or...

FWIW, I'll be at
- Louisville
- Baton Rouge
- Oslo
- Cambridge
- Pittsburgh

Probably all for me. Maybe Lincoln since it's so close.

Yeah, that's bad. Anyone joining EAV to other tables regularly have issues. If you use them sparingly, EAV makes sense.

I feel for you, that's a bad design. If...

Interesting idea. I'll kick it around.

Since Ken is on vacation, I'm uploading the key.

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,...