If I take a database offline, or remove all users from the database and set it to single user mode, does the cache clear? Are those entries for plans, data, etc., removed from memory?
According to MSDN,
The plan cache for the instance of SQL Server is cleared by setting one of the following options:
No one has followed this question yet.