How to Interact with SQL Server’s Data and Procedure Cache

by Randy Dyess – As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool t

Read More - Register for Free Membership