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

You can read about clustering here: https://msdn.microsoft.com/en-us/library/ms189134%28v=sql.110%29.aspx

There is no such thing as two nodes, each read/write to the same database. That isn't supported in SQL Server and never has been....

Lynn Pettis (5/20/2016)

---

GilaMonster (5/20/2016)

---

Ed Wagner (5/20/2016)

---

ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017. I hope you can make...

Feb 2017, Detroit. Noted. I will try to make this a priority.