Viewing 15 posts - 16,471 through 16,485 (of 22,226 total)
siddartha pal (9/22/2009)
1:There are 4 process involved but the no of process nodes appearing...
"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
September 22, 2009 at 8:33 am
This node, along with another, had a deadlock, on a page, 6:1:96560 (databaseid:fileid:pageid). This node is the victim, the spid that got killed and rolled back. Based only on 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
September 22, 2009 at 8:20 am
Either the path where backup is placed doesn't exist or context under which SQL Server is running doesn't have access to it.
Or, it's the issue that SilverFox spotted.
"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
September 22, 2009 at 8:13 am
Cost is how much the query costs, on average, to run. The user impact is how much of that cost is going to be saved or reduced. They're definately different...
"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
September 22, 2009 at 6:53 am
It's blank. If you're posting XML, you need to use the code listing on the left
[ code = "xml" ]
Just remove the extra spaces.
"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
September 22, 2009 at 6:34 am
Sorry, I can't read it. It's too small and the resolution isn't high enough for me to make out the words even after I blow it up.
"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
September 22, 2009 at 6:33 am
In general, the narrower the index, the more keys that get packed on to a page, the quicker the seeks. So, with the INCLUDE, you're taking two columns out of...
"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
September 22, 2009 at 6:30 am
Silverfox (9/22/2009)
How much can you receive for aricles posted here?, just out of comparision 😀
Less, but the article length requirement here is not as long. You don't go through 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
September 22, 2009 at 5:35 am
Roy Ernest (9/21/2009)
Damn... Thats pretty good. 🙂 So the standard will be pretty high... Then my article is probably going to be rejected... :hehe:
I'm not sure how high the standard...
"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
September 21, 2009 at 7:23 pm
Yeah, you can't really directly compare one execution plan to other as such, you just evaluate each one to see if there are issues.
Yes, it's a Star Fury. B-5 is...
"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
September 21, 2009 at 1:04 pm
Assuming this is a multi-statement query, you could try capturing the Statement completion event within a trace. It's going to return an awful lot of data, so you need 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
September 21, 2009 at 12:56 pm
Although, usually, half as many reads is pretty much the end of the story. I'd check the execution plan though, see what differences there are there.
"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
September 21, 2009 at 12:40 pm
Maxer (9/21/2009)
Table1 and Table2.
I UNION both and add a column called "Origin" that says "Table1" for table 1 and "Table2" for table...
"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
September 21, 2009 at 12:38 pm
I'm sorry, I'm reading through the code there and I'm not sure what your error message is.
"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
September 21, 2009 at 12:36 pm
Lynn Pettis (9/21/2009)
Grant Fritchey (9/21/2009)
Lynn Pettis (9/21/2009)
Grant,One very important question, copyright on the article, who owns it?
You do.
We get exclusive rights for... some period of time I don't recall, 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
September 21, 2009 at 12:10 pm
Viewing 15 posts - 16,471 through 16,485 (of 22,226 total)