table data stored into cache memory.

Question

0 down votefavorite I want to add mostly required table's into cache memory (Master tables) in SQL server.Next time retrieve all data from table which is in cache memory.How can i do this?

Dhananjay Kumar · Answer

https://msdn.microsoft.com/en-us/library/cc293623.aspx

ketan borsdiya · Answer

Hi Atul Follow below link http://www.codeproject.com/Articles/756423/How-to-Cache-Objects-Simply-using-System-Runtime-C

Dhananjay Kumar · Answer

https://msdn.microsoft.com/en-us/library/aa478965.aspx

Atul Patil · Answer

I want answer in SQL server. Not in ASP.NET. So please help me.