It's been a very mixed bag around here. Some of the general principals have survived for a couple of years, daily stand-up, short term planning, precise definition for those short...

I thought it was because you were playing the French?

GilaMonster (6/25/2009)

---

Yeah, I know. It's not me. I'm not on Twitter at all.

There's a GilaMonster@gmail, a GilaMonster at DeviantArt[/url] and someone with GilaMonster as xbox gaming tag, that I know...

Miracles can happen.

Woo hoo!

http://news.bbc.co.uk/sport2/hi/football/internationals/8114585.stm

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