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

I have Win 10, VS 2010, 2013, 2015. All seem stable, though I don't really use VS2010 anymore.

I tend to use Git for VCS, and this is an option in...

Resource Governor is Enterprise Only - https://msdn.microsoft.com/en-us/library/cc645993%28v=sql.110%29.aspx

If you are running enterprise, I'd buy more CPU/RAM to take advantage of capabilities. Certainly you can use RG to limit CPU by user,...