Viewing 15 posts - 14,161 through 14,175 (of 22,224 total)
Alvin Ramard (10/6/2010)
Are we there yet?
See what I miss by trying to have a life & stuff. Gotta stop doing things away from The Thread.
"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 6, 2010 at 7:22 pm
Steve Jones - SSC Editor (10/6/2010)
Grant Fritchey (10/6/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
October 6, 2010 at 7:16 pm
Alvin Ramard (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
Well, it wasn't me, Jeff, or Gail. It was Alvin that hit it, so congrats.
Thanks. I'm still in shock. I can't...
"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 6, 2010 at 7:14 pm
Alvin Ramard (10/6/2010)
Celebration time!!!!! 😀
And another celebration in about 250 posts as we pass 1,000,000 on the counter.
"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 6, 2010 at 11:55 am
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/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
October 6, 2010 at 11:54 am
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?
They're...
"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 6, 2010 at 11:42 am
Will lights go off or horns sound or a little HUZZAH sound come out of the speaker for the person who hits 1m?
"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 6, 2010 at 9:25 am
If you stop the profiler trace, then click on File, Export, Script Trace Definition, and then select the version of SQL Server you want to output it for, you 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
October 6, 2010 at 9:21 am
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
That sentence is WAY too long:
Wow, loading data into Access is a Royal PITA
"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 6, 2010 at 9:18 am
Visual Studio Team System has a set of validations that can be run against your SQL code. They came out of what used to be the 2000 Best Practices Analyzer....
"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 6, 2010 at 9:17 am
parthi-1705 (10/6/2010)
barry.smallman (10/6/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
October 6, 2010 at 9:02 am
Yes, the interim table approach will allow for data integrity. But I wouldn't try to do the universal interim table. Despite the fact that it adds to the number 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
October 6, 2010 at 8:59 am
Alvin Ramard (10/6/2010)
Kit G (10/6/2010)
Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Now how many members of the thread will be coming...
"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 6, 2010 at 7:18 am
samalex (10/6/2010)
Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll...
"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 6, 2010 at 7:16 am
I don't completely understand what's going on, so please excuse my ignorance.
First, can you explain in further detail why you can't have constraints?
I'm not a huge fan of GUIDs,...
"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 6, 2010 at 6:37 am
Viewing 15 posts - 14,161 through 14,175 (of 22,224 total)