Viewing 15 posts - 17,431 through 17,445 (of 22,219 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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2009 at 6:28 am
Viewing 15 posts - 17,431 through 17,445 (of 22,219 total)