We have very similar requirements. We do it like this:

SELECT...

FROM MyTable m

WHERE m.VersionId = (SELECT TOP(1) m2.VersionId

...

Brian Tax (7/8/2008)

---

I have solved this, but I am an not sure why. If I add the column EmpBen.TrackingID it runs fast and the plan is differnent, it uses...

How come you don't need to add the scalar operator, '0 [Basic]', to the * version of the query? If you did add that, would it change the execution time?

Jeff...

I'd need to see the execution plans to be sure, but I'll be you're getting index lookups for the column list, but not for the SELECT *. Can you post...

Steve Jones - Editor (7/8/2008)

---

I almost hit a guy once. Paged me on a Thur night while I was out with my wife, just to see "if I was available"....

Honestly, I think it's a crutch. I haven't seen a well-planned design use it.

Some are friends, some aren't.

That about sums it up. I do agree that avoiding the occasional excess drinking when it occurs is a good choice if you want to move...

Based on nothing by my own personal experience...

What getting into Harvard gets you, these days anyway, isn't a superior education, but a superior name. You're a Harvard Grad (capitols required)....

I got this wrong as well. I've seen both STATIC & FAST_FORWARD work better in different circumstances. "It Depends" should have been the right answer on this one.

Nope.

You can use SSIS to do the work for you, but the analysis is up to you.

The only way I know of will hurt your performance. You can put FAST 1 hint on the query and it will start returning data immediately. It will however, really...

Gail is on the money here, totally.

Instead of trying to avoid having multiple queries, accept the fact that you will have multiple queries and then get some code to generate...

Posting the execution plan would help in the evaluation. Not seeing your structure and only seeing a query, we're all limited to making guesses.

I can't honestly say that I wouldn't have hit the guy. Nice exercise in restraint.

9 months at a start-up run by Harvard grads who's operating phrase was "Think Outside The Box." This extended to every single part of the company. One of the more...