Chad Crawford (4/2/2010)

---

I'm thinking out loud now, but I'm a little nervous about relying on the snapshot to not miss a new object type that someone creates next month

Jeffrey Williams-493691 (4/2/2010)

---

Yeah - I have used both and can recommend either of them.

Paul White NZ (3/22/2010)

---

Same goes for the CHAR conversion (if done with a deterministic style) and FLOAT (2008 only).

Gianluca Sartori (4/1/2010)

---

At this point I wonder why case-sensitive servers allow creating linked servers with non-uppercase names.

It would be a great time saver if only uppercase names were allowed.

Trey Staker (4/2/2010)

---

Answering the question a day late with the answer published in the news letter?

david_wendelken (4/2/2010)

---

a1. Check for duplicate. Passes.

b1. Check for duplicate. Passes because process a hasn't inserted YET.

a2. Insert new record.

b2. Insert new record. There's a duplicate.

david_wendelken (4/2/2010)

---

I know this may sound silly, but why not put a unique key index on the GUID column?

CirquedeSQLeil (4/2/2010)

---

I sit here and wonder how those people at the top are nearly perfect in the QOD with so many that were wrong.

homebrew01 (4/2/2010)

---

Thanks for the feedback. Would a synonym work with a function that is in another database as I'm trying to do in my first post ?

Paul White NZ (4/2/2010)

---

Yay! My apply articles have been scheduled!!! 12^th & 19^th April - excited :w00t:

Thanks Steve!

Steve Jones - Editor (4/2/2010)

---

You should read Brent Ozar's blog on the MCM (http://www.brentozar.com/archive/tag/mcm/), especially today.

CirquedeSQLeil (4/2/2010)

---

I envision the MCM being completely different.