Nice Article.

Thanks

The backward compatibility in this scenario is "SQL Authentication." If you never use SQL Authentication, you would not need to use SA either. MS is trying to have...

paul.goldstraw (2/19/2010)

---

I liked it like that. It was nice to know that short of copying it letter for letter or using OCR to read the text back, everyone answering should...

Grant Fritchey (2/19/2010)

---

Jack Corbett (2/19/2010)

---

I've considered it, but I've also talked to people who have done it (Grant being one)...

Nice question.

When will we see books from Jack, Lynn and Gus?

AndrewSQLDBA (2/18/2010)

---

You should never use the sys admin account for anything. That is only for backwards compatibility. Not sure why it is even still in here.

Create a simple SQL user...

Interesting site bouncing around twitter today by the MVPs.

Decided to check out

http://www.uservoice.com

signed up under http://sqlrnnr.uservoice.com

Woohoo - finally made it to 5000 :w00t:

Waiting Tasks

The number of tasks that are waiting for processor,...

Gail, Barry, and Elliott have put it very succinctly.

If you really want slightly different performance from one of the system procs, create on of your own that fills that requirement...

ahh but DBCC Payincrease requires DBCC Timewarp in order to function properly.

dennisengel (2/18/2010)

---

Sorry for replying so late, Thanks everyone for your suggestions.

Step 1: I had restored these databases to another server from backups, and kept business going. I has good...

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

GilaMonster (2/18/2010)

---

It's not.

Cleanly shutdown is indicated by...

As the posts now stand - no violation of NDA has occurred. I wouldn't sweat it.