This article describes how to configure SQL Server to use more than 2 GB of physical memory.
Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires an
Read More - Register for Free Membership