Viewing 15 posts - 17,101 through 17,115 (of 22,210 total)
Been there, got the t-shirt. I'm glad it all worked out.
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.
June 25, 2009 at 8:30 am
Alexander Kuznetsov (6/25/2009)
June 25, 2009 at 8:17 am
tosscrosby (6/25/2009)
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...
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,...
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,...
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.
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...
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...
June 25, 2009 at 6:56 am
Gianluca Sartori (6/25/2009)
I don't' remember such a rainy and (relatively) cold summer...
June 25, 2009 at 6:38 am
Paul White (6/24/2009)
June 25, 2009 at 6:29 am
Alexander Kuznetsov (6/24/2009)
June 24, 2009 at 1:28 pm
Can I ask what types of scripts you're looking for? Do you mean scripts to monitor blocking?
June 24, 2009 at 12:46 pm
Viewing 15 posts - 17,101 through 17,115 (of 22,210 total)