http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/22/3-0-changes-in-caching-behavior-between-sql-server-2000-sql-server-2005-rtm-and-sql-server-2005-sp2.aspx3.1 Costing algorithm change between SQL Server 2000 and SQL Server 2005 RTM In SQL Server 2000 and 2005, the cost of a query depends on 3 factors: number of disk IO requests, number of context switches during query compilation (in 4 ms quantumsen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/22/3-0-changes-in-caching-behavior-between-sql-server-2000-sql-server-2005-rtm-and-sql-server-2005-sp2.aspx#6583366Wed, 28 Nov 2007 22:01:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:6583366SQLGEEK <p>Kontynuując niejako temat cache'u plan&#243;w wykonania zapytań w SQL Server 2005 (vide Parametry procedur</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=6583366" width="1" height="1">http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/22/3-0-changes-in-caching-behavior-between-sql-server-2000-sql-server-2005-rtm-and-sql-server-2005-sp2.aspx#5170698Thu, 27 Sep 2007 19:48:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:5170698PSS SQL Server Engineers<p>Our entire PSS team had a great time presenting and meeting many customers at last week's summit. Thank</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=5170698" width="1" height="1">http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/22/3-0-changes-in-caching-behavior-between-sql-server-2000-sql-server-2005-rtm-and-sql-server-2005-sp2.aspx#1527267Thu, 25 Jan 2007 11:58:20 GMT91d46819-8472-40ad-a661-2c78acb4018c:1527267EXEC dbo.LongTermMemory__Archive<p>As I once mentioned in a post I felt that the procedure cache was really out of proportion. We were...</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=1527267" width="1" height="1">