Please show your query, and then work on explaining the logic a bit more. It will help if you use quotes to show actual text that should be replaced, and...

Brandie Tarvin (4/6/2011)

---

I heard Disney was doing G-Force and got all excited.

Then I found out it was about guinea...

Battle of the Planets/G-Force, I loved that. I'll have to show the kids. I got one kid to try StarBlazers and he really enjoyed the second or third season. I...

Doh! I do need some QA. I must have typo'd it while adding the image.

Here's the URL: http://www.schneier.com/blog/archives/2010/10/hacking_trial_b.html

I found this, from Bob Beauchamin, who I think is very knowledgeable on stuff like this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70053

Basically the XML updates are singletons, so you need two update statements as this...

GSquared (4/5/2011)

---

Just the other day, someone was telling me that, "If you'd lived through the Reagan years ...", without realizing I lived through "the Carter years" and have some slight...

Michael has some good questions. Replication, BTW, is not repetition or repeated rows. It also means something else in SQL Server.

I missed the sentence about duplicate values, and my apologies....

CirquedeSQLeil (4/4/2011)

---

I read the line leading into the commentary about Zune and it gave me pause. Steve alluded to SSC going to a subscription model where access to certain...

Randy Rabin (4/5/2011)

---

Steve,

Just to say up front that I've never used Connect so no first-hand experience. But, could it be that they've just closed the window for new functionality for...

Not an assumption, or it wasn't for me. I had 4 items closed with no comment. A week or so later...

David McKinney (4/5/2011)

---

Hi Steve,

I agree with you on the overall. However, I didn't quite understand your specific reference to the "brilliant" duplicate indexes note.

Could you expand on this?

Thanks...

Thanks to everyone. I enjoyed it at as well. Look for it again next year.

Thanks, I'm the last man standing, but certainly not the winner. Final standings:

Johan - 14

Allen - 10

Steve - 9

Bradley - 8

Sean - 7

sqlRaider - 6

Mark - 4

Dean - 4

I'll shoot...

Don't forget to think about running this for a year to catch those once a year processes.

If you think about removing anything, make sure you get a script of the...

It is permissions. OS 5 is access denied from Windows.

there has to be something weird going on there. Can you run this on your system and perhaps see permissions and...