Good article, Steve, with a lot of interesting points. In my current job situation we're way too short staffed to be able to take much time off to do...

Thanks, Bob.

Dang, that is sweet. I guess I'll have to develop some logic to filter on the largest media_set_id for the backups I'm interested in. Before I go too...

WOW, good explanation, Celko! I hope that one day we'll be able to upgrade to SQL 2008 R2 or SQL 2012. Fortunately for me, this was an ad...

GSquared (8/27/2012)

---

UPDATE/DELETE FROM work in all versions of SQL Server that I've worked with, including SQL 2000, 2005, 2008, and 2012. MS isn't planning on removing them. If...

Lynn Pettis (8/27/2012)

---

Rod at work (8/27/2012)

---

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE...

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE was to be favored; and...

For me, it is overwhelmingly in favor of "Fix".

Thanks.

IowaTechBear (8/3/2012)

---

We have a few hundred databases spread across our state in multiple data centers. Our standard backup policy (to Tivoli TSM) is a weekly full backup, nightly differentials and...

1 production

1 developer/test, which is a copy of the production

Steve Jones - SSC Editor (8/2/2012)

---

We have "Newbies" forums in all areas, or most of them. This...

ralph.bacon (8/1/2012)

---

So true. I'm a "solutions provider" / "developer" / "current vogue name" writing SQL-based intranet (dot net) solutions.

Whilst I have a rough idea of what is going on behind...

cksid (7/31/2012)

---

I'm not a true DBA admin. I work with the SQL tables and such. I would like to learn how to set this up. Can someone...

I've never heard of this. Probably because I'm an accidental DBA. I think it is a brilliant idea! I'm going to be watching this thread with great...