Viewing 15 posts - 16,681 through 16,695 (of 22,226 total)
It really depends on too many factors for me to comment. What service pack do you have installed? I had a lot of problems with the Tuning Advisor until 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
August 24, 2009 at 9:59 am
Jack Corbett (8/24/2009)
Dave Ballantyne (8/24/2009)
Ive got a bad feeling about thishttp://www.sqlservercentral.com/Forums/Topic775882-338-1.aspx?Update=1
Ah, that's a good one. I think the issue with that one is due to language. I think...
"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
August 24, 2009 at 6:48 am
Dave Ballantyne (8/24/2009)
Ive got a bad feeling about thishttp://www.sqlservercentral.com/Forums/Topic775882-338-1.aspx?Update=1
That's no moon. It's a space station.
"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
August 24, 2009 at 5:48 am
So, to get the number of rows you'd just modify the query to do a count
SELECT COUNT(*)
FROM table
WHERE col = '2'
It's just a straight aggregate function. If 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
August 24, 2009 at 5:48 am
The data I initially tested with was distributed about the same as yours. I was using AdventureWorks.SalesOrderDetail & the ProductID. 870 has 4,688 rows & 897 has 2 rows. But...
"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
August 21, 2009 at 1:02 pm
TheSQLGuru (8/21/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
August 21, 2009 at 12:02 pm
TheSQLGuru (8/21/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
August 21, 2009 at 11:15 am
Any time you see radical differences in performance, you need to identify the differences. Are you passing different parameters? Are you testing it on a different server or with different...
"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
August 21, 2009 at 10:56 am
jcrawf02 (8/21/2009)
Grant Fritchey (8/21/2009)
Alvin Ramard (8/21/2009)
GilaMonster (8/21/2009)
Alvin Ramard (8/21/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
August 21, 2009 at 10:51 am
Alvin Ramard (8/21/2009)
GilaMonster (8/21/2009)
Alvin Ramard (8/21/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
August 21, 2009 at 10:24 am
RBarryYoung (8/21/2009)
Lynn Pettis (8/19/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
August 21, 2009 at 8:29 am
GilaMonster (8/21/2009)
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx
Oh, sure. Shoving bamboo shoots under my finger nails is starting to get...
"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
August 21, 2009 at 7:33 am
What you have are what are referred to as correlated sub-queries. As a general concept, they're not bad or dangerous, but when over-applied, and I think you're there, they become...
"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
August 20, 2009 at 8:44 pm
Alvin Ramard (8/20/2009)
Can anyone suggest a user group website that would be a great example of what a great user group website should look like?...
"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
August 20, 2009 at 4:57 pm
Are both systems structurally identical? Do both systems have exactly the same data in them? Do both systems have the indexes defragged and the statistics updated in exactly the same...
"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
August 20, 2009 at 1:25 pm
Viewing 15 posts - 16,681 through 16,695 (of 22,226 total)