I sure don't mean to start a fight with my next statement....

Please don't do that. Learn to use the ANSI joins. There are a ton of good reasons. I'll give...

Hmmm... I just ran the test and received no difference between truncate and delete.

I think you're looking for something like this:

select c.date

from spdqty as c

inner join (select date, vialsOUT from spdqty) as a

on c.date = a.date

inner join (select date, vialsIN from spdqty)...

So, you've got two tables that have three different and distinct relationships between the tables? I'm pretty sure that violates one of the rules of normalization, but I'm not sure...

160gb is not small, but I've used Profiler (in a limited fashion) back in 7.0 on 300gb databases. That was before the improvements to the tool in 2000. You should...

From my own experience and everything I've read, no, the order doesn't change the selectivity. It will affect sorting speed. If you need to retreive the data in a particular...

The data in an insert trigger is contained in a set called INSERTED that you can treat just like a table. So if you wanted to capture the data all...

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