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

That is really cool, Grant, thank you!

I'm afraid that unless it is free, my management won't consider it, so SQL Prompt is out, as is anything else that costs.

Ah, programming. Definitely where I feel most "at home", as I am a programmer first, and then an accidental DBA second. However, I've been programming for a long...