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

"Not able to access the database..." It's a permissions issue. Your service account, or the account you're calling from, don't have access to the appropriate databases. That's it. Check your...

SQL Server is the backbone of the product I've been developing for most of my career.  I'm also in the 61 club.  I've even mentioned that retirement is on...

So anyone got suggestions on things to do in Seattle in two weeks, after the Summit is done for the day, for someone who won't have a...