Viewing 15 posts - 14,191 through 14,205 (of 22,232 total)
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, 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
October 6, 2010 at 5:34 am
John__A (10/5/2010)
Grant Fritchey (10/5/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 5, 2010 at 1:55 pm
Alvin Ramard (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
Perhaps Gail could practice some archery in view of the office. Maybe aim for low down on the torso 😛
Waving a shiny piece...
"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 5, 2010 at 1:54 pm
I can't point to specifics, but I've seen anecdotal evidence that suggestions in some edge cases, the changes to the optimizer between 2000 and 2005 can product sub-optimal execution plans....
"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 5, 2010 at 11:39 am
GilaMonster (10/5/2010)
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...
"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 5, 2010 at 11:24 am
A friend of mine just posted an excellent little PowerShell script that might be something you're looking for. Check out Aaron Nelson's blog post[/url].
"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 5, 2010 at 11:01 am
The problem with a lot of the perfmon counters and a recommended value is that so much of it depends on the system where you're running them. For example, I/O...
"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 5, 2010 at 10:58 am
Piling on a little bit, I think Steve sells himself a little short. Basically, if I wanted to learn something in or around SQL Server, he lists the three sources...
"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 5, 2010 at 10:53 am
CirquedeSQLeil (10/5/2010)
Grant Fritchey (10/5/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 5, 2010 at 10:38 am
mtillman-921105 (10/5/2010)
pjdiller (10/5/2010)
I'm short. Don't tall people make more on the average? :discuss:From what I've heard on the news, more tall people become managers.
That's because we can see...
"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 5, 2010 at 9:29 am
Steve Jones - SSC Editor (10/5/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 5, 2010 at 8:53 am
I wouldn't try it that. Instead, script out the 2008 database to a script or set of scripts. Then you can run those on the 2005 instance, fixing what you...
"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 5, 2010 at 7:45 am
Men want to stop playing these games and just do the job.
Will that day ever come?
"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 5, 2010 at 7:29 am
Exactly what Gail says. You can use the list she provided earlier as the basis for your server side trace.
"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 5, 2010 at 7:29 am
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?
Yes, I know there are many queries or sysyem sp's that cannot be 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 5, 2010 at 7:06 am
Viewing 15 posts - 14,191 through 14,205 (of 22,232 total)