Oooh. That's a good one.

Been there, got the t-shirt. I'm glad it all worked out.

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.

Alexander Kuznetsov (6/25/2009)

---

I want the opposite - I want security on test boxes to closely match production security, and I want no hassle at all. That's what I use roles...

tosscrosby (6/25/2009)

---

Chicago HAD been consistently wet and cool for spring, around 70F. But the summer solstice hit this past Sunday and we are now in the 90s. It was nice,...

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...

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,...

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,...

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.

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...

Do what Gail says. Avoid functions on columns in the WHERE clause and JOINs. Use operations that can...

Gianluca Sartori (6/25/2009)

---

Maybe I could, but the main problem is that it's always raining... The grass grew almost to my knees...

I don't' remember such a rainy and (relatively) cold summer...

Paul White (6/24/2009)

---

The SQL Server Algebrizer (which replaces the 'Normalizer' in 2000) does a fair amount of this work, including helping to decide on parallelism, how to approach sub-queries and...

Alexander Kuznetsov (6/24/2009)

---

I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste...

Can I ask what types of scripts you're looking for? Do you mean scripts to monitor blocking?