Convert the NOT IN statement to a LEFT JOIN and only select values where the key from the second table are NOT NULL. That's much more likely to make good...

You have to issue a USE statement or quantify the object names in the queries with the database name. Neither method supports using a parameter which is why all you'll...

This will work with 2000:

SELECT

A.RetailerID,

b.RetailerIDTheirs

FROM TableA AS A

LEFT JOIN TableB AS B

ON A.RetailerID =...

The short and long answer in this case is, it depends.

There are a lot of variables involved in this sort of thing and the right answer in one case isn't...

Only 62 tables. We had one that was 85 and we got it to run in under 2 seconds (of course, it took 12 minutes to recompile).

But seriously, everyone else...

I'm not sure this is what you're looking for, but maybe using the OUTPUT clause?:

INSERT INTO Person

OUTPUT PersonId INTO #Temp

.....

There's not really fine-grained control that will allow you to manipulate the cache in that manner. I have heard of a number cache problems with the release version and SP1....

Excellent. Thanks for reporting back what worked.

It's a general rule that you should have a clustered index on every table (there are exceptions and exceptions to the exceptions). For detailed discussion of why this is so,...

Yes, that's true. It won't help you bury the bodies. In fact, it usually digs them up, like a dog. Traitors!

Sounds like it could be parameter sniffing. Check the execution plans to see if they're changing between the non-parameratized values and the parameratized values. You can try a couple of...

And, deadlocks are an error that can be captured with a TRY/CATCH statement in TSQL. You can try resubmitting the query a certain number of times before you finally give...

The proc cache is your bestest buddy. Why on earth do you want it cleared out all the time? What problem are you trying to solve?

Gail's 100% on the money here.

If you just look at the differences you can see why. A view is simply a select statement kept around in a way that sort...

Just to take a slightly contrarian point of view.

We did a lot of testing and found, depending on the number of columns and the type of data in a table,...