Viewing 15 posts - 18,631 through 18,645 (of 22,226 total)
Using COALESCE or ISNULL in the WHERE cluase usually prevents SQL Server from using an index on the query if one exists. Forcing the query to perform only table or...
"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 25, 2009 at 5:35 am
Tweaking the disk, especially from RAID 10 to RAID 1, is only going to get you a marginal increase in performance. I'd concentrate on the queries, indexes (full text indexes...
"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 8:02 am
Sure, it makes sense. It even works well a good percentage of the time. There's still that disconnect between Person & Employee that has to be documented and explained 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
January 23, 2009 at 7:06 am
Personally, I'd stick with RAID 10. The added safety is worth more than a small increase in speed.
You've collected performance data and the bottleneck is I/O and you've tuned 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
January 23, 2009 at 6:43 am
That's a very open ended question. I don't know what kind of work you need done.
I'd start them off writing TSQL queries so that they begin to understand how databases...
"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:40 am
Yep, right there in the BOL. I had to look it up just to verify.
"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:29 am
There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER. I'd recommend testing your system with TOP or ROW_NUMBER because, in my experience, MAX generally doesn'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 23, 2009 at 6:28 am
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
Viewing 15 posts - 18,631 through 18,645 (of 22,226 total)