Jeff Moden (8/18/2011)

---

f you can afford it, I'd buy a copy of the "Developers Edition". I don't know what the latest price is but I've heard anywhere from $45...

Good clear question.

Too early in the morning though - after a late Friday night I shouldn't try to think properly before breakfast has restored normal brain function.

Lynn Pettis (8/19/2011)[hrMonday will be the start of a new day. I will be starting my new job at Progressive and getting back to working with the BEST RDBMS...

bars

Ditto too

Evil Kraig F (8/18/2011)

---

I see it as the first step needed for ORM and RDBMS to start liking each other...

Really nice useful feature.

Marios Philippopoulos (8/18/2011)

---

...

Sproc code is more easily accessible than a CLR assembly, even if the production server has been highly secured.

Databases are usually restored from prod backups on QA and...

Jeff Moden (8/17/2011)

---

As you may have surmised (and some already know from other threads), I've been seriously considering writing about the 3 secure methods to safely use narrow-scope stored procedures...

Good question, good clear answer.

Rather a lot (60%) of people getting it wrong, surprisingly.

If it was worth saying...

GSquared (8/17/2011)

---

ALZDBA (8/17/2011)

---

Evil Kraig F (8/17/2011)

---

Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspx

Seems like a...

Kenneth Wymore (8/17/2011)

---

Nice question. I knew better than to choose truncate as not being logged because of previous QOTD's and articles regarding this same thing. the truncate does not log...

Yes, it's a good question.

Interesting and somewhat horrifying...

Roy Ernest (8/16/2011)

---

We have a new Celko in the making. Yes, the SP he had was bad, but keep calling it a peace of garbage is not going to help...