Multiple posts on the same topic just confuses things. Let's keep the discussion on this, over here at the link. Thanks!

It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger people...

Oh, it's not that bad. They'll let you look. Just get...

Ooh, I so feel this.

One I see all the time, and I'm sure you do too, is when traveling internationally, depending on your flights, blah, blah, blah, you end up...

Generally, it'll cause CHECKDB to fail. However, I've seen it where it takes the server offline. This is because the rollback that has to occur, also needs some disk space,...

Migrating between data platforms is a massive undertaking. It's not just data types, although that's a big part of it. You also have to take into account connection mechanisms within...

Just know that moving data OUT of Azure costs money.

Couple of things. It's now maintaining an index in addition to simply dumping data into a heap. Also, depending on how your data is ordered on retrieval, you may be...

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