• SQL Server 2008 has an option called "optimize for ad hoc workloads"

    Please see whether is helpful to you.