Ed Wagner (11/30/2014)

---

Koen Verbeeck (11/27/2014)

---

It's time to allow for moderators (privileged forum users) to be able to delete spam.

Most of the succesful forums/boards/whatever have this. Just not SQLServerCentral.

I think as...

Voted as 174.

I'd like to see this, if for no other reason than it makes vandalism harder and it's trivial to implement. A DMV that has 32B (int's worth) could...

I love the function of just adding values together, though I feel uneasy that it might not work in 2100 and beyond. Course, not sure we need to plan on...

Let's hope that Harvin sprains an ankle and can't go, but is healthy for next week. :w00t:

70+% US.

Chances are you've lost this database. You should never detach it or uninstall. You need to be able to examine the database when it's suspect.

If you don't have backups, there...

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum has proportionally...

grant alter on the schema to a role and then grant create table/view/proc to the role.

Add users to the role.

Clustered index is a book. The works in the order in the book are the index. Nonclustered indexes are the index in the back of the book. Selected...

Andrew..Peterson (11/24/2014)

---

So, how does this tool, SQL Lighthouse, differ from RedGate's tool that does a comparison between databases? It is really just a comparison tool, right. Or does...

Iwas Bornready (11/24/2014)

---

I'm a little confused. If you are talking about changes to production outside of a normal release, then this certainly is high risk, unless it goes through the...

Yep, hundreds of spam posts and I realize its frustrating. Believe me, since I end up managing them on the weekends, its annoying.

And VPN is down, so I can't even...

I'm not sure it's completely backwards. Hundreds of messages are being deleted.

The problem on Fri/Sat is that we get thousands of messages, and dozens of new accounts created to submit...

lshanahan (11/21/2014)

---

I've read up on them (don't remember if I read Paul's article, but I will check it out), but to understand something I really have to sit down and...

Indeed, though I was neither of those things. I was...