Viewing 15 posts - 17,446 through 17,460 (of 22,219 total)
I live about 1/2 mile from here.
"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
May 15, 2009 at 6:24 am
Lynn Pettis (5/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
May 15, 2009 at 6:20 am
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
Oh, you don't have to be Klingon to do...
"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
May 15, 2009 at 6:17 am
Just chiming in as someone getting started with PowerShell. Well done. Thanks for the work. I'm still just digging through it all & figuring it 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
May 14, 2009 at 1:08 pm
2 Big boxes?
"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
May 14, 2009 at 7:33 am
Jacob Pressures (5/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
May 14, 2009 at 7:11 am
PaulB (5/14/2009)
sabutp (5/14/2009)I am not sure in MS SQL but in Sysbase SQL separate indexes are created automatically for primary and foreign keys.
MS SQL Server != Sybase
They departed ways...
"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
May 14, 2009 at 7:08 am
You should probably try generating the database as a script, recreate it, empty, and then migrate the data over. You could continue using SELECT statements or you might want 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
May 14, 2009 at 7:06 am
That's a huge topic. If you're expected to deliver all this stuff NOW and you don't know how, you really are over your head. However, this is a high level...
"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
May 14, 2009 at 6:56 am
It really depends on the query being run. Most of the time, a JOIN is the preferred methodology. However, there are queries where the IN statement will work just as...
"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
May 14, 2009 at 6:54 am
The the vast and overwhelming majority of systems, you should do both.
The algorythm that decides whether or not to update statistics is pretty good, but it's not perfect. Most people...
"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
May 14, 2009 at 6:51 am
Sounds like a good problem to have.
Buy a big box, with lots of memory... Sorry, but no one can help much past that without a lot more definition of 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
May 14, 2009 at 6:42 am
I think this one will require application of the Mk1 Eyeball and the 19xx release of Brain.
There are too many variables possible for a script to automate the process. For...
"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
May 14, 2009 at 6:41 am
I agree, it depends.
A large majority of our applications have transaction control from the code, not within the procedures, so while we use TRY/CATCH error handling, we don't have 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
May 14, 2009 at 6:35 am
No index is automatically created when you create foreign keys.
"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
May 14, 2009 at 6:23 am
Viewing 15 posts - 17,446 through 17,460 (of 22,219 total)