Viewing 15 posts - 14,641 through 14,655 (of 22,227 total)
Jack Corbett (7/15/2010)
"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
July 15, 2010 at 12:12 pm
CirquedeSQLeil (7/15/2010)
With another one coming up very quickly 😉
Where? When? I don't know what you're talking about.... again
"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
July 15, 2010 at 12:10 pm
Alvin Ramard (7/15/2010)
Steve Jones - Editor (7/15/2010)
Grant Fritchey (7/15/2010)
Alvin Ramard (7/15/2010)
We're considering using LiveMeeting in Memphis so that more people could "attend" the meeting.
We've talked about it a few times,...
"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
July 15, 2010 at 9:33 am
Alvin Ramard (7/15/2010)
We're considering using LiveMeeting in Memphis so that more people could "attend" the meeting.
We've talked about it a few times, but there hasn't been a lot of interest...
"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
July 15, 2010 at 8:22 am
Does it hurt anything? Not really.
But what a total waste of space and time. Maintenance and long term readability is reduced, not enhanced. It's a throwback to the old days...
"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
July 15, 2010 at 6:50 am
Paul Farnell (7/15/2010)
"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
July 15, 2010 at 6:46 am
Please don't post in duplicate locations. It just diffuses the conversation.
All replies to this thread please.
"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
July 15, 2010 at 6:36 am
GilaMonster (7/14/2010)
Nat Na (7/14/2010)
About Parameter sniffing, I only saw it happens in procs. Is it possible for querys from appl?
Can happen any time there's parameterised queries.
And how can...
"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
July 15, 2010 at 6:16 am
Jeff Moden (7/14/2010)
"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
July 15, 2010 at 5:47 am
Paul White NZ (7/15/2010)
Fraggle-805517 (7/14/2010)
Paul,That works perfect. Thank you very much. That will solve the problem.
Fraggle.
Good. By the way, I think Grant was thinking of the system...
"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
July 15, 2010 at 5:38 am
There are multiple ways you could do that. Personally, I'd go with using PowerShell from the 2008 server. You can issue file commands to copy the file and then issue...
"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
July 15, 2010 at 5:38 am
SwedishOrr (7/14/2010)
"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
July 15, 2010 at 5:32 am
Is the SQL Server 2005 a 64 bit install? If it's a 32 bit version, it'll be trying to load the 32 bit version of the commandlet. I've run into...
"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
July 14, 2010 at 2:52 pm
Whew! Standard deadlock. You've got INSERT & DELETE statements in there. So the deadlocks are not from the shared locks alone. There's more at work, a lot more.
So, standard questions...
"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
July 14, 2010 at 2:46 pm
Novicejatt (7/14/2010)
"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
July 14, 2010 at 12:41 pm
Viewing 15 posts - 14,641 through 14,655 (of 22,227 total)