Viewing 15 posts - 16,321 through 16,335 (of 22,219 total)
s ss (10/14/2009)
Bob Hovious 24601 (10/14/2009)
This is why people who waste our time are irritating, as are the people who insist that their problems are urgent and somehow more deserving...
"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 14, 2009 at 10:23 am
In 2008 you could make a table variable and pass that between stored procedures, but you'd probably still need to make it an output parameter to get it back out...
"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 14, 2009 at 10:05 am
Can you post the execution plans?
"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 14, 2009 at 9:52 am
Excellent. Now tell me what color your parachute is and you're hired.
"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 14, 2009 at 9:48 am
An output parameter from Sp2 would be available within sp1. Have you tried that?
"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 14, 2009 at 9:40 am
It's possible to do a cascade delete, but to do a cascade update, not so much. You're not actually removing the address value, you're changing which one the customer points...
"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 14, 2009 at 8:20 am
Can you do it? Yes. Should you do it?
You're running into the same situation that lots and lots of people have run into with clustering. They're trying to have it...
"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 14, 2009 at 7:56 am
However large the log file is, it is. There's nothing wrong with a large file. But... it does raise the concern that you're logging operations that should not be, that...
"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 14, 2009 at 7:50 am
chris.warriner (10/14/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 14, 2009 at 6:56 am
mtucker-732014 (10/13/2009)
Im not sure the qualities of any great figure in history, let alone Generals would be ideal for a DBA, those people tend to be tremendously...
"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 14, 2009 at 4:09 am
jcrawf02 (10/13/2009)
Roy Ernest (10/13/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 13, 2009 at 4:51 pm
Roy Ernest (10/13/2009)
All of you are going to wear Kilt? Can we the of THE THREAD who cannot make it get a pic so that we can see? 🙂
Roy,...
"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 13, 2009 at 4:48 pm
Since most of the denizens of The Thread are not on Twitter, I should spread the word here as well. In my absolute dictatorial power as no one of consequence,...
"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 13, 2009 at 1:31 pm
blandry (10/13/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 13, 2009 at 8:50 am
skjoldtc (10/12/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 13, 2009 at 8:46 am
Viewing 15 posts - 16,321 through 16,335 (of 22,219 total)