Viewing 15 posts - 16,261 through 16,275 (of 22,226 total)
Jack Corbett (10/23/2009)
"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
October 25, 2009 at 12:11 pm
Jeffrey Williams-493691 (10/23/2009)
fred2002 (10/23/2009)
i explained it wrong.
first we restricted the size to 300MB
But now due to the errors we allw it to 1.2GB.
MS advise to fix a max size 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
October 23, 2009 at 6:17 pm
Oh gosh, you're joining and unioning on views. That's potentially the cause of the problem right there.
Looking at the execution plan you've got about 12 different scans, several key lookups...
"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
October 23, 2009 at 6:14 pm
Piotr.Rodak (10/23/2009)
This would be SQL 2008 Grant 😉Regards
Piotr
Oh nuts am I bleeding over again? How come everyone doesn't just upgrade to 2008 and be done with it. It'd sure be...
"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
October 23, 2009 at 12:47 pm
It really depends on data integrity. If you're dealing with what is essentially unstructured data, then yes VARCHAR(MAX) is the way to go. If you've got a structure, then no,...
"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
October 23, 2009 at 6:54 am
Since you're posting this in the 2005 forum, you could use the Date data type. It's only 3 bytes. That's one less than smalldatetime and 5 less than datetime.
"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
October 23, 2009 at 6:48 am
There's nothing immediately obvious in the query that would suggest a performance bottleneck. The hard coded values of "0" do beg the question, how selective is that data, are you...
"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
October 23, 2009 at 6:45 am
I agree with what everyone else has said, and, I wouldn't discount query tuning. It might be working OK with the set of data in one database and poorly with...
"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
October 23, 2009 at 6:42 am
mahesh.vsp (10/23/2009)
What is the major difference between index seek and index scan?
I have read few articles where in index seeks yields better performance.
What exactly happens in case of index...
"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
October 23, 2009 at 6:40 am
To use the log you'd need to track down a third party tool that allows you to read it. There's no way natively to read from it.
Other options, in addition...
"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
October 23, 2009 at 6:30 am
Usually this occurs when the log is trying to grow to accomodate a transaction if the log is in simple recovery. You probably need to monitor the log size much...
"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
October 23, 2009 at 6:22 am
I'll be there and at the SSC party.
"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
October 23, 2009 at 6:19 am
Yes, absolutely the difference in data types will prevent the indexes from getting used. It's an implicit conversion and they look like magic and therefore free, but it's just 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
October 23, 2009 at 5:29 am
sanokistoka (10/22/2009)
"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
October 22, 2009 at 4:53 pm
bitbucket-25253 (10/22/2009)
Grant Finchley
Anyway, that's the one thing I'd like to see. More direct support for the local users groups
Grant used Live Meeting to make a presentation to the Columbus SQL...
"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
October 22, 2009 at 10:58 am
Viewing 15 posts - 16,261 through 16,275 (of 22,226 total)