Check out this excellent article @ MSDN:
Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005

Nice post about concurrency... be sure to read the comments too!

If you're into Reporting Services check out http://sqldbatips.com/showarticle.asp?ID=62
This is a nifty little tool that scripts your reports for deployment on other servers, it also generates a handy batchfile for the deployment.