You deserve a lot of credit for bringing people, quite literally, to the table to talk. Well done.

And thank you for all your help over the last couple of years.

The size of your log backups over time are a very good indicator as to how much stuff is passing through the logs.

Yeah, you do have to take care of yourself. Otherwise things get rocky. And happy to help anywhere I can.

Since you don't need realtime, the cheapest and easiest way will be backup and restore. Nothing to it.

Oof. Even if you put an index on the SpoolSrtDt column, because you have a function to convert the value you're going to get scans anyway. Why do that? It's...

Thank you Grant. I know this was a broad one. I will enable the query store (of course I'm assuming that it does not effect things too much) to...

Lots of differences between 2014 and 2019. It's hard to say that it's going to be any one thing in particular. Your best bet is to do a bunch of...

Well that was one heck of a three days...

First Summit Seattle under my belt and I'm both burned out and still geeked.  I wasn't able to attend even 1/2...

What's this "we" stuff. I'm a film school...

Guess it depends on how the optimizer likes it. Either approach can be valid, depending.

Instead of removing the original question, you could have posted the solution so that if others hit it, they can benefit. Just a thought.

Personally (and I can hear the collective groans), I'd put Extended Events to work on the database. Capture all queries run against. The reason I say this, index usage stats...

I lean towards, let's try, as much as possible, to simply avoid linked servers. They're very attractive appearing. Looks like a simple, clean, quick, and most of all EASY, way...

An easy way? No.

There just isn't a mechanism that shows, this column, or this table was read. Instead, you can capture query metrics using Extended Events and filter that on,...

Since you aren't qualifying a single column as to who owns it, the optimizer will try to figure out what you're doing. I believe, in the end, that last query,...