Viewing 15 posts - 17,116 through 17,130 (of 22,226 total)
Miracles can happen.
Woo hoo!
http://news.bbc.co.uk/sport2/hi/football/internationals/8114585.stm
"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
June 25, 2009 at 9:55 am
Oooh. That's a good one.
"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
June 25, 2009 at 9:53 am
Been there, got the t-shirt. I'm glad it all worked out.
"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
June 25, 2009 at 9:09 am
OK. So they are the same then. What's the view doing for you? It's clustered key is the same as the underlying table.
"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
June 25, 2009 at 8:30 am
Alexander Kuznetsov (6/25/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
June 25, 2009 at 8:17 am
tosscrosby (6/25/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
June 25, 2009 at 7:17 am
If you want, you can query between databases by qualifying the database objects with the db name? Is that what you're looking for? Otherwise, you have to switch databases 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
June 25, 2009 at 7:14 am
If you're having trouble meeting all the configuration requirements for AdventureWorks (and Gift is right), there is a Lite version that you can use. It's much easier to install. Unfortunately,...
"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
June 25, 2009 at 7:10 am
Can you post actual execution plans for each of the queries?
Since you're testing it on two different servers, are you 100% positive that the same data exists in each? Also,...
"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
June 25, 2009 at 7:06 am
At this point, this is a cross-post with this one:
http://www.sqlservercentral.com/Forums/Topic741702-338-1.aspx
Please don't ask the same question in multiple places. I posted a possible answer in the other location.
"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
June 25, 2009 at 7:03 am
I'd have to see the execution plans of the queries to be sure, but I'll bet you the table and the index have the same key. If you're doing an...
"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
June 25, 2009 at 6:59 am
Eswin (6/25/2009)
How to avoid clustered and non-clustered index Scan's and also table scans.
Do what Gail says. Avoid functions on columns in the WHERE clause and JOINs. Use operations that can...
"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
June 25, 2009 at 6:56 am
Gianluca Sartori (6/25/2009)
I don't' remember such a rainy and (relatively) cold summer...
"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
June 25, 2009 at 6:38 am
Paul White (6/24/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
June 25, 2009 at 6:29 am
Alexander Kuznetsov (6/24/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
June 24, 2009 at 1:28 pm
Viewing 15 posts - 17,116 through 17,130 (of 22,226 total)