InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 20:37:10 GMT20http://www.sqlservercentral.com/Forums/Topic1380868-65-1.aspxok, thanks, will re-post it again.Mon, 05 Nov 2012 18:47:21 GMTangel.wong 72408http://www.sqlservercentral.com/Forums/Topic1380868-65-1.aspxThis is a SQL Server 2000 forum that is buried at the bottom of the forums page. You may want to post your question to the SQL Server 2012 forum:[url=http://www.sqlservercentral.com/Forums/Forum2799-1.aspx]SQL 2012 - General[/url]Mon, 05 Nov 2012 09:01:19 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1380868-65-1.aspxI found out that it seems flush from memory very soon make it unable to use the cache data, results in slow to getting results.1) How long will it cache the data? 2) Any setting can be set for the interval of caching?3)Any hot fix /patches in SQL2012 to solve this issue?Sun, 04 Nov 2012 21:30:57 GMTangel.wong 72408