A big key is the Join can actually utilize any indexes that exist for that column when joining. The in is generating a simple const list to compare against or...

Remember to ask for a payraise and and nice corner window office.

I guess that was simpler.

Read here on Performance Tuning.

http://www.microsoft.com/technet/prodtechnol/bosi/maintain/optimize/bostune.mspx

Every bit of documentation I so far have read from MS states the log file is handle via sequential IO. So no matter how many...

I think that may be the biggest point, design. Poor design can be hidden by the way an application deals with it. Make something perform well even with a poor...

Could also be your implementation, which is generally the case more then the DB.

Just my added 2 cents...

Or if you choose not to use a Stored Procedure at least use a ADOBB.Command object and parameterize your sql statement. Works Exactly the same as...

Ken Henderson's books are among the best especially for under the hood check out

Guru's Guide to SQL Server Architecture and Internals

Here is my review on it.

http://www.sqlservercentral.com/columnists/jtravis/reviewofgurusguidetosqlserverarchitectureandintern.asp

And then you might...

I have to say I have had no issues with connection pooling in VB6 and I have to say I don't like sloppy coding and dangling connections that are not...

Yes and as wilth all exception you put code to handle. Also each time you need to perform a process you should check the connection object exists and that the...

Actually no won't slow down at all. COnnection pooling does't truely drop the connection like you would think. I puts it off for a quick reuse until the poolts timeout...

I suggest you writer a select query for your source and change you object like so.

Ex (Assumes a column for zip code defined as int with constraint 00000-99999)

SELECT

RIGHT('00000' + CAST(zip...

SOrry SQL is not desgined to give you near machine access as it is a proprietary system. They do provide various methods to talk with objects they provide for some...

I agree you shouldn't be using a cursor as a set based method can easily perform. On top of that if the other table is like a snapshot of the...

CLosing your object and destroying it is a good practice from a memory standpoint. It does not hurt the server in any way for the connection to be closed and...