Viewing 15 posts - 16,456 through 16,470 (of 22,219 total)
Roy Ernest (9/23/2009)
It is very quiet... And where is Gail? Is she doing fine? It has been long time since I have seen her comment.
I've talked to her offline. She's...
"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 23, 2009 at 8:27 am
Sorry I'm late to the party Lynn. This is a fantastic article. It's practically a how-to on writing a good performance test article. Well done.
"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 23, 2009 at 6:36 am
Jack Corbett (9/22/2009)
Grant Fritchey (9/22/2009)
Jack Corbett (9/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
September 22, 2009 at 5:20 pm
Jack Corbett (9/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
September 22, 2009 at 12:06 pm
SSSolice (9/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
September 22, 2009 at 11:30 am
Just an insert is not a cause for deadlocks. You've got to have more than one process attempting to get exclusive access to a row or page. Two shared locks...
"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 9:06 am
jcrawf02 (9/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
September 22, 2009 at 9:03 am
Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong 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
September 22, 2009 at 8:36 am
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
Viewing 15 posts - 16,456 through 16,470 (of 22,219 total)