You put the clustered index on a bit column? Very odd choice since there are only two possible values there. It's not a very good index, clustered or nonclustered, and...

I try to fall to moving as little data as possible, so if you have a mechanism of tracking create/update date, then use that as part of your polling process...

So, a key lookup operation is added cost. However, there is not reason to automatically attempt to remove that cost unless you determine that in fact that key lookup operation...

So the complaints aren't coming from the developers or a design team or something, but from someone looking at a report? Oh, to heck with that then. Yeah, just say...

I'm not exactly a normalization Nazi, but I think they have a point. You're overloading the behavior of that column. From a normalization standpoint, that's pretty much a violation of...

Extended Events. You can easily capture the logins and filter to only a single database. It's the least obtrusive way to get this done.

Looking at it again, an interesting thing is that the output from the Hash join is estimated at 2,000 rows and is actually 10k. That's the opposite direction of the...

Sure, you can send a command to force a failover. That's the easy part. The hard part is that you're going to have to constantly poll the database to see...

That is a big difference. I'm not sure why you're seeing that without checking the statistics to understand what the values that the plan is compiling for represent there.