January 2, 2012 at 11:48 pm
For one of my requirement I want to cache the data in a table. This table will be dynamically formed with data from different tables. Is there any way by which we could cache data in SQL 2005, the way we used to do it in .Net.
January 3, 2012 at 5:51 am
Maruthi Shangar (1/2/2012)
For one of my requirement I want to cache the data in a table. This table will be dynamically formed with data from different tables. Is there any way by which we could cache data in SQL 2005
As far as I know DBCC PINTABLE functionality is gone in SS2K5.
Forcing a full table scan, index scan or selecting into a temp table will cache the data and it will stay there until it ages out and space is needed for other more used data... if what you are "caching" is used often enough it will stay cached virtually forever.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 3, 2012 at 6:58 am
How big is the table? If it’s 2 GB in size would you like to cache it? What if another reports requirement comes to you that need such dynamic data? Would you cache another table?
Generally speaking you should rely on database default caching mechanism. There are better ways to tune report queries. Please provide use your reporting requirements, DDLs, scripts, sample data & query execution plans (actual). We will try to help you tuning queries.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply