Viewing 15 posts - 14,131 through 14,145 (of 22,219 total)
Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.It's nice to see everyone can learn.
I...
"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 3:51 pm
Best thing you can do is pick up a copy of Itzik Ben-Gan's Inside SQL Server TSQL Querying. Make all the developers read that. That'll do more positive than any...
"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:37 am
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
Viewing 15 posts - 14,131 through 14,145 (of 22,219 total)