>When running the site with SQL Server, I have found that the access to certain tables will take longer at first because the tables haven't been accessed yet. So, at first, it may take a little bit longer to process the hit. So, on big tables, I might end up with a Timeout expired message. I need to increase that in the database. Where can I go to adjust that?

Just use the .NET SQLCommand.CommandTimeout property.
HTH,
Viv