(I know. American readers will tell me off for not spelling it Optimizing but I'm English so I can't help it!)

 I was going to put the whole article here but I thought I'd try out a new publishing tool/service called HubPages.

So the article is here instead.

It covers a whole range of tricks including index creation, use of stored procedures, locking techniques, avoiding nested queries on the same connection and a bunch of other things which if you want reasonable scalability and performance from a SQL/ASP website it's important to take into account.... and sadly too many people don't (and then wonder why their site is really slow!)