Viewing 15 posts - 16,441 through 16,455 (of 22,226 total)
Also, is the data exactly the same on both servers. Are you passing identical parameters on both servers. Assuming both of the above are yes, are the indexes and structures...
"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 25, 2009 at 12:32 pm
It stays on until you turn it off or turn it on for another table, so did you test the inserts to tableA at some point in the past?
"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 25, 2009 at 12:28 pm
Usually, delete the data in the referring tables first. Alternatively you could set up your foreign key constraints with cascading deletes. This is considered a dangerous approach, so it's not...
"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 25, 2009 at 12:26 pm
Alter the table, add the column as nullable, copy the data over, drop the other column at a later date. That should minimize downtime on the system.
Otherwise, you've outlined 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 25, 2009 at 12:24 pm
Scalability Experts has a free tool called the SQL Server 2008 Upgrade Assistant. I used it a few times and it does most of what you're looking for. I'd check...
"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 25, 2009 at 12:18 pm
Alvin Ramard (9/25/2009)
Roy Ernest (9/25/2009)
Still a long way to go. I am getting lots of positive feed backs from the people who attend. They are coming up...
"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 25, 2009 at 11:42 am
Alvin Ramard (9/25/2009)
Roy Ernest (9/25/2009)
Still a long way to go. I am getting lots of positive feed backs from the people who attend. They are coming up...
"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 25, 2009 at 11:38 am
Flat out, it depends. I get something from Jeff, Gail, Lynn, the usual suspects, I will review it and test it, but I'll generally assume it's right. I get something...
"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 25, 2009 at 6:50 am
Roy Ernest (9/24/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 25, 2009 at 5:22 am
It can be useful for troubleshooting. You can see the transactions by name if you select sys.dm_tran_active_transactions.
"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 24, 2009 at 12:22 pm
You'll have to walk through the database using some type of cursor and calls to DBCC SHOW_STATISTICS in order to look at the database statistics.
As already stated, unless you put...
"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 24, 2009 at 11:11 am
Roy Ernest (9/24/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 24, 2009 at 7:34 am
I'd strongly suggest taking SilverFox's second suggestion and use sys.dm_index_physical_stats. There's more information to be had in a clearer fashion than from the older showcontig statement.
"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 24, 2009 at 6:41 am
Silverfox (9/24/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 24, 2009 at 6:39 am
Yes
"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 24, 2009 at 5:58 am
Viewing 15 posts - 16,441 through 16,455 (of 22,226 total)