Is the deadlock occurring every time you execute the statement? If so, you've got a fundamental problem somewhere. If you can, in addition to getting the traceflag data as Gail...

It sounds like one or more of your databases is in full recovery mode but you don't have log backups running.

I do feel your pain. I work as a development dba, so I straddle both disciplines although the overwhelming majority of my work is straight database work.

It does require a...

I just finished moving another 10 servers into the new data center. They all passed consistency checks after the move. Praise the gods. That's 33 on Wednesday & 10 more...

Luke L (5/15/2009)

---

I live near here

View Larger Map

For all you folks out in Mass, I'm planning a trip trough Boston up to the Cape this summer. Any...

David Burrows (5/15/2009)

---

Thanks Grant. 🙂

The advantage is that only 10 minutes walk and I am in woodland with open views of the...

DUDE! I've visited that place before. How cool...

There just isn't enough information to really answer your question. I want to follow-up & seriously suggest you get someone with a bit more experience to help out.

Oh, that place looks great. I loved it in England!

GilaMonster (5/15/2009)

---

Ahhh!!!! Damn it! Twice this year!

Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody...

I live about 1/2 mile from here.

Lynn Pettis (5/14/2009)

---

The sun has set in the deep desert and lone figure sits quietly meditating next to a small camp fire. While sitting there, he simply cannot believe...

Oh, you don't have to be Klingon to do...

Just chiming in as someone getting started with PowerShell. Well done. Thanks for the work. I'm still just digging through it all & figuring it out.

2 Big boxes?