don't think so. Those use the VDI interface, which doesn't freeze IO, but rather...

Yes, undocumented

The rearrangement of information is intended to make keeping things up to date easier for MS and to prevent stale pages. I'm not sure this works great, but I understand...

I still think this is more complex than fixing your process. Replication is brittle, and when it fails, it's a pain to reset. I'm also a bit concerned about you...

It's complex, and I think step #3 can perhaps be more difficult that you imagine. How are you sure the data is up to date? If you do maintenance, are...

I typically wouldn't expect more than one file in the primary filegroup, but there are certainly reasons to do this. Not sure you get benefits on the same drive like...

Perhaps you want to explain what you want to do, or not want to happen. You can do this, but as noted above, this may not be what you expect....

I haven't. It looks complex, and one of our Redgate developers came from a company doing it. He...

Thanks, everyone.

My oldest graduated from college last year, so this is the second high school graduation for us. My middle kid has been accepted into university (UC Boulder), but is...

I really dislike opening statements like this. You are almost implying that someone reading this should...

paul.bowman (5/24/2016)

---

Also sometimes what appears to be the natural primary key, from the point of view of the data model and retrieval use cases, turns out to be the wrong...

Well, I hate intentional walks in the adult league. They eat up time for no reason, but I've never seen a bad throw. Probably because the catcher just stands wide.

However...

Back from the weekend. Looked like most of you behaved.

My weekend

+1

The idea given above from BaronGreen.bak is what I'd do. Have a job query this one for time, and then stop it if it's taken too long.

Be careful and be...