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

Kevin doesn't like writing. I need someone that wants to document and describe an issue.

You'll need logic in there that looks for e:\ and replaces with d:\. You might need to create folders ahead or build in logic to do so.

For the two...

It is hard to get resources to make changes. Adding users to moderate is something we don't take lightly, especially since most of you are quicker to whack things you...