Viewing 15 posts - 18,631 through 18,645 (of 22,219 total)
So did you try what I laid out in the post you put up yesterday?
http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx
If it didn't work, what went wrong?
"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
January 23, 2009 at 6:18 am
timothyawiseman (1/22/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
January 23, 2009 at 6:09 am
GSquared (1/22/2009)
As an aside, how often in a DBA's career does it really matter that pages are 8k in size, if that's what was being looked for?
We ask...
"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
January 23, 2009 at 5:57 am
I'd want counts one those numbers too. Is the 254 an extreme outlier or just slightly high? I haven't run averages on my systems recently, but 20ms just for recompiles...
"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
January 23, 2009 at 5:50 am
Instead of your usual high quality posts, put up a slip-shod one or two... you'll earn a pork chop.
:hehe:
"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
January 22, 2009 at 12:08 pm
Bob Hovious (1/22/2009)
Watch out... Cardinal Moden may be lurking about somewhere close by with pork chop in one hand and a fish in the other.😉
I've been force-fed his chops...
"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
January 22, 2009 at 11:31 am
DBADave (1/22/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
January 22, 2009 at 11:12 am
Bob Hovious (1/22/2009)
GilaMonster (1/22/2009)[hrWell, it's not the join keyword and it's an old way of doing things, and the outer join syntax only works in SQL 2000 and earlier, but
from...
"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
January 22, 2009 at 11:05 am
GilaMonster (1/22/2009)
gyessql (1/22/2009)
select ...
from table t1
inner join t2
...
"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
January 22, 2009 at 10:09 am
Andrew Reilly (1/22/2009)
You need to watch out for any *= or =* joins in the where clause as this is no longer supported!
The Upgrade Advisor will catch that, as well...
"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
January 22, 2009 at 7:34 am
Me neither. Same things Gail said. Plus, 2005 offers a few things that improve performance, reducing contention, helping to prevent deadlocks.
"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
January 22, 2009 at 7:13 am
Oops. There I go again not reading everything before posting.
You can't.
"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
January 22, 2009 at 7:07 am
gyessql (1/22/2009)
select t1.*
from table1 t1
inner join table2 t2
...
"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
January 22, 2009 at 6:30 am
You also might consider using EXISTS rather than a count. It will work faster
IF EXISTS (SELECT * FROM TabA)
BEGIN
END
ELSE IF...
"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
January 22, 2009 at 6:18 am
Plese don't cross-post. This leads to multiple people attempting answer the questions in more than one location.
I have also posted an answer to this question here: http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx
"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
January 22, 2009 at 6:08 am
Viewing 15 posts - 18,631 through 18,645 (of 22,219 total)