lnardozi 61862 (5/22/2013)
Would a shrink maybe put more of the database into the cache?
No. The only things that go into cache are allocated pages and all shrink does is move allocated pages from the end of the file to as far forward in the file so that it can release the free space to the OS, it doesn't reorganise the rows onto fewer allocated pages, that's index rebuild or reorg.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass