I have found even very small tables like 10 row lookup tables can benefit. I have flip-flopped on this one several times but typically I include an identity column...

Hi vince,

I think this is a great script. I wish I had seen it when is was first posted 🙂

I wonder if you have updated or modified...

I don't see how any query can avoid a table scan given a condition like "all company names that contain the word THE".

I have used this technique to meet some...

I don't understand the facination with VM Ware or Virtual Server for Production SQL.  Any machine with enough power to host mulitiple virtual machines is certainly has enough power to...

I concur with Michael.  I use indentity integers as primary keys almost exclusively.  I place a Unique constraint on the natural key column if it seems advisable for data base integrity...

Hi William,

I agree with Bledu.  I use table variables A LOT.  Generally they are every thing you want a temp table to be and more.

There are a couple of things...

We require all application access to use Stored Procedures.  In fact the app users do not Select, Insert, .. privileges at all.

When there is a complex select I use various Stored...