Viewing 15 posts - 17,416 through 17,430 (of 22,204 total)
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...
May 18, 2009 at 12:27 pm
Florian Reischl (5/18/2009)
SQL Server 2008 Enterprise...
Yep, I stand clarified. Compression is available only on Developer & Enterprise versions.
May 18, 2009 at 10:57 am
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...
May 18, 2009 at 7:37 am
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...
May 18, 2009 at 6:49 am
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...
May 18, 2009 at 6:47 am
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...
May 18, 2009 at 6:41 am
It sounds like one or more of your databases is in full recovery mode but you don't have log backups running.
May 18, 2009 at 6:39 am
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...
May 18, 2009 at 6:22 am
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...
May 15, 2009 at 11:08 pm
Luke L (5/15/2009)
For all you folks out in Mass, I'm planning a trip trough Boston up to the Cape this summer. Any...
May 15, 2009 at 10:09 am
David Burrows (5/15/2009)
Grant Fritchey (5/15/2009)
I live about 1/2 mile from here.
Thanks Grant. 🙂
The advantage is that only 10 minutes walk and I am in woodland with open views of the...
May 15, 2009 at 6:57 am
GSquared (5/15/2009)
Lynn Pettis (5/14/2009)
Well, since we are showing about where we all live, here is where I live.I'm here (most of the time).
DUDE! I've visited that place before. How cool...
May 15, 2009 at 6:36 am
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.
May 15, 2009 at 6:33 am
David Burrows (5/15/2009)
hereNo mountains only a few hills
Oh, that place looks great. I loved it in England!
May 15, 2009 at 6:29 am
GilaMonster (5/15/2009)
Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody...
May 15, 2009 at 6:28 am
Viewing 15 posts - 17,416 through 17,430 (of 22,204 total)