Viewing 15 posts - 16,546 through 16,560 (of 22,219 total)
Unless the two databases were identical in every possible way, you couldn't transfer the statistics (not that you can). But if they are identical in every possible way, the generated...
"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 14, 2009 at 7:52 am
Micrososoft has an Upgrade Advisor that will check your 2000 database to see if it has any deprecated code, so you can fix it before there are errors in 2005...
"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 14, 2009 at 7:49 am
Jack Corbett (9/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
September 14, 2009 at 7:05 am
David.Poole (9/14/2009)
There will always be people who complain about...
"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 14, 2009 at 5:40 am
giaks0wn (9/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
September 14, 2009 at 5:38 am
RBarryYoung (9/11/2009)
Grant Fritchey (9/9/2009)
Jeff Moden (9/9/2009)
Grant Fritchey (9/9/2009)
WHOOP!I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
:blush: Heh... that's odd. ...
"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 12, 2009 at 6:25 am
That's a real subjective question, but the two I can recommend because I've worked with them professionally and have had nothing but good experiences are End to End Training and...
"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 11, 2009 at 11:10 am
9/11/01 was a pretty messed up day. I had just been laid off from a failing startup the week before. The kids started their first day of pre-school that day....
"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 11, 2009 at 9:31 am
Does the SSIS package do anything besides insert the data? Maybe the statistics are getting updated as well. If not, maybe they need to be.
"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 11, 2009 at 7:37 am
Just a note, right in the upper right hand part of the screen on this web site is a little text box with the label "Search:" to the left 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 11, 2009 at 7:33 am
Jack Corbett (9/11/2009)
Silverfox (9/11/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 11, 2009 at 7:09 am
Jeff Moden (9/9/2009)
Grant Fritchey (9/9/2009)
WHOOP!I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
:blush: Heh... that's odd. I was going...
"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 9, 2009 at 8:19 pm
WHOOP!
I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
"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 9, 2009 at 4:43 pm
GilaMonster (9/9/2009)
Grant Fritchey (9/9/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 9, 2009 at 1:58 pm
It's hard to say for sure, not knowing your queries, your structure or anything about your system.
Probably, those two indexes will work. They both have the same leading edge (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 9, 2009 at 1:47 pm
Viewing 15 posts - 16,546 through 16,560 (of 22,219 total)