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

Ray K (5/20/2016)

---

When...

hjp (5/20/2016)

---

Currently, we are upgrading from 2005 to 2014 in one go. It works nicely, mainly because I spent the better half of a month Googling and planning, and everything...

Never made the event in Atlanta. I'd like to, but timing seems to fail. My middle kid graduates tomorrow, so no can do.

You could have a role in production created that has your permissions and then a script to add your login/user to the role when the restore happens. Or if...

Ed Wagner (5/20/2016)

---

Brandie Tarvin (5/20/2016)

---

So...

Installing our new prod servers. Was doing swimmingly until I got to the Add Node to Cluster. Got to the account / password page of the...

One note, this is to make it easier to clean the SPAM here.

Part of the issue is that this database is too denormalized. The insert for a new thread hits...

New threads are from new users, so I wouldn't want that.

I did track down yesterday that the reports of SPAM were getting lost. That's been corrected, so myself and a...

Jeff Moden (5/19/2016)

---

TheRedneckDBA (5/19/2016)

---

What about charging a one-time small fee to be a user of SQLServerCentral.com? Something like $2? (Or whatever the minimum charge would have to be...

Thanks, Jeff. Hoping for a few pieces. We have the one you wrote on moving a scalar UDF to a CROSS APPLY, but I'd like to get more references for...

TheRedneckDBA (5/19/2016)

---

What about charging a one-time small fee to be a user of SQLServerCentral.com? Something like $2? (Or whatever the minimum charge would have to be to break...