You would have to use a user defined function as Chirag mentions above. Doing that in the where clause is pretty likely to lead to RBAR (row-by-agonizing-row) processing, which kills...

If you limit the events captured to only what you really need (especially staying away from capturing individual statements) and you use the extended stored procedures to fire off Profiler...

A bit of both really. Plus, if you haven't been here, you might not know. This place is kind of big. There's a lot of empty space and we tend...

It really depends on where you're driving to as well as the distance. I used to commute about 30 miles down I-90, the Massachusetts Turnpike, and it took about 1...

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