Browsing ASP/ HTML
ASP to static HTML for speed
If you have a large amount of data to give to the user as HTML and this data needs to change once a day then this will speed up the process for the user.
Client Side Excel Spreadsheet
You can create an Excel Spreadsheet on the client side with a HTML data stream.
Bust the cache!
This code allows you to force a page to reload from the server, rather than the user's browser cache.
Calling Command objects and stored procedures
You can design stored procedures to hide complex business rules and logic, leaving a more concise interface available for application development.
Batch Update using ADO
ADO has a great batch update feature that not many people take advantage of.
Transactions are atomic operations that allow you to do multiple operations on a database as one operation.
ADO GetRows example
You can use ADO GetRows to output and ADO recordset to an array.