Viewing 15 posts - 16,261 through 16,275 (of 22,219 total)
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
It will be tough. There just arn't that many starting positions as a DBA. Lots of us came out it through other means, tech support, systems, or development (my own...
"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 5:43 am
PASS does put on a Summit in Europe. It's not as big or as well advertised as the Summit in the US (usually in Seattle these days), but it's pretty...
"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 5:41 am
Even if these query passed the parallelism threshold with such a small number of tables and a few rows, the splitting and marshalling of the streams would make the query...
"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 5:35 am
You can simply run both queries within a single stored procedure and then deal with the multiple result sets on the client side.
I don't see any other options since 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
October 22, 2009 at 5:31 am
Sorry, one of the noisy 50 still making noise.
The PASS Summit is one of the best networking events I've ever seen. The way that the leaders in the community reach...
"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:46 am
This is a huge topic. I'd suggest picking up a copy of my book (linked below). You could also start with reading Gail Shaw's articles over here at Simple-Talk[/url].
"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 21, 2009 at 4:48 pm
Yep. Those values in actual execution plans are also estimates. The values for rows, cpu, stuff like that in an actual plan are real values, but the operator costs are...
"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 21, 2009 at 7:55 am
Viewing 15 posts - 16,261 through 16,275 (of 22,219 total)