Yeah, hard coding isn't perfection, but, that's the situation. Work within it.

The negative is, that index probably won't be used for a lot of SELECT queries since it doesn't eliminate...

Yeah, it should work as described.

Ordering by a function is just going to kill you more and more as the data grows. Best suggestion I can make is to not do that. Nothing will make...

Nothing marks a table as being "used" by queries. You can look at sys.dm_db_index_usage_stats, assuming the table in question has indexes. That will tell you something of the access...

Create a file group in a different location and move those indexes to that file group.

Your best bet to see missed connections is setting up an Extended Event session and capturing the even connectivity_ring_buffer_recorded. That's the one mechanism I know that captures stuff like timeouts....

By default, neither. It supports both. Extended Events is first though. We have several metrics that are taking...

OOps. Sorry. And yeah, that's really odd.

Another one?

Test

Post 16 in test

Sounds like you have encrypted connections enabled, but haven't set up certificates for those connections. How do you resolve it after the reboot currently?

Not one I've personally hit, but it looks like it's likely to be a permissions issue based on this article from Microsoft.

It is...

First time I've hit. Just a little test, since I'm only running on a local machine with a container for a database, turning off Encrypt and you don't need the...

Latency?

I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.