• SQL Server will always use all the memory you make accessible to it.

    Unless you specifically enforce releasing previously cached pages.

    Normally SQL Server will keep cached execution plans, data sets in memory until they become irrelevant (say, changed stats change plans) or server needs to free some memory for new queries.

    _____________
    Code for TallyGenerator