I agree with Lowell. From the description, the index is woefully inadequate for the data and the optimizer assumes a scan will work better. But there must be more to...

Yep, I stand clarified. Compression is available only on Developer & Enterprise versions.

I'm in agreement with Gail on this, why are you returning millions of rows?

If you really want to understand why the query is running slowly, you need to examine the...

There is no mechanism within SQL Server 2005 to compress data. You can get third party tools to compress the backups (Red Gate, Ultrabac, Quest Litespeed), but only SQL Server...

I don't know of, nor have I heard of any mechanisms for data compression prior to SQL Server 2008. You can get third party software that will compress backups for...

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