Yes - store the current date into a variable - you should get a boost just from that

Good 2005 reference, coding, performance, and some admin:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584340.html

khostip - just visit msdn.microsoft.com -- you'll find answers to this and other questions that you posted

Colin - yes the book "Sql server 2000 performance tuning - technical reference" is a good reference.  I'll include it in the reference area if we re-print the article anywhere....

Great article Randy - resource friendly solutions are always nice to come across

Nice Article Jon!

We do web development and db work for clients and have been using a fairly good host - but my gripe with their company is that they have a ton...

Thanks for the reply Bimal.  I read an article similar to what you mentioned, again it stressed the need for the same file structure. 

I was hoping there is a...