Viewing 15 posts - 14,146 through 14,160 (of 22,232 total)
At this point in time, coming up on 2011, SQL Server 2005 is six years old and 2008R2 is 9 months old. There'll be a new version (either SQL Server...
"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 8, 2010 at 11:33 am
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Grant Fritchey (10/8/2010)
what is it we do for work again?
Work is a four letter word. My mother taught me to behavior better...
"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 8, 2010 at 9:03 am
Chris Morris-439714 (10/8/2010)
Grant Fritchey (10/8/2010)
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/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 8, 2010 at 8:40 am
steveb. (10/8/2010)
Pradyothana Shastry (10/8/2010)
Check the indexes and as well as fragmentation level toowould an upgrade change the fragmentation level?
Assuming either a restore or attach style upgrade.... nope.
There are some...
"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 8, 2010 at 6:22 am
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/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 8, 2010 at 6:08 am
I'm a huge fan of side-by-side upgrades. So far, knock wood, I haven't had a single 2008 upgrade go wrong, but if one did, having the 2000 server sitting there...
"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 7, 2010 at 1:13 pm
Prayer and living sacrifices to the gods...
Barring that... It's not that bad. It could be worse. It could be SQL Server 6.5.
Standard stuff. Make sure you have backups in place....
"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 7, 2010 at 1:04 pm
Brandie Tarvin (10/7/2010)
jcrawf02 (10/7/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 7, 2010 at 12:38 pm
Gianluca Sartori (10/7/2010)
hahnorlaska (10/7/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 7, 2010 at 11:24 am
Alex-815008 (10/7/2010)
I'm surprised there is such a limitation because I thought that actually it was common for there 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
October 7, 2010 at 11:23 am
Alex-815008 (10/7/2010)
I've searched that article for "resolution" since that seemed to be a key part of what you were saying, but I only found references 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
October 7, 2010 at 7:52 am
vijay1327-891581 (10/7/2010)
But the problem is the company does NOT allow to run the profiler due to some policies. hence I was trying to find if ther...
"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 7, 2010 at 7:06 am
Alex-815008 (10/7/2010)
Grant Fritchey (10/7/2010)
Because one of those errors is dependent on resolution of action, it's not caught by the TRY/CATCH. It's explained here.
Which link in that reference should I follow...
"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 7, 2010 at 7:02 am
I'd look at the other wait states and queues on the system. You know you're getting lots of disk i/o's, but why? You need to figure out what is causing...
"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 7, 2010 at 6:48 am
Without the execution plan it's just guess work to what's going on. Remember, just because you see an index referred to in the execution plan doesn't mean it's being used...
"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 7, 2010 at 6:45 am
Viewing 15 posts - 14,146 through 14,160 (of 22,232 total)