Both SQL Server and SQL Azure have a procedure cache which is used to improve the performance of queries on the server. This blog post will talk about how the procedure cache works on SQL Azure. SQL Azure has a pool of memory that is used to store both
Read More...
Read the complete post at http://blogs.msdn.com/b/sqlazure/archive/2010/07/28/10043450.aspx