I probably won't have the example, assuming I can find it, until tomorrow. I'm looking though.

I did find this in the BOL

This sequence can sometimes influence the results of the...

I'm going to start digging, but I've had instances where moving filtration from the WHERE clause to the ON clause does change the execution plan. I don't have the example...

There's an "Anti-Rbar Alliance"?

How do you join? How much are the dues? Does the initiation involve sheep or goats?

You got it essentially right. SQL Server 2000 support ended... in May I think. That's main stream support. You can still pay to get access to PSS. The same thing...

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