Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
beza
Starting Member
16 Posts |
 Posted - 2009-11-16 : 10:19:46
|
| HeyI have a 30 million rows table partitioned by time stamp, each partition is a day.I usually select information from the last week partitions, I heard there is a way I can keep only those 7 partitions in the RAM for faster access.is it true? if yes, how do I configure such a thing ? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-11-16 : 13:30:47
|
| There used to be DBCC PINTABLE, but I beleive that was depercated in 2008. So, I don't know of a way to do it in 2008. |
 |
|
|
|
|
|
Hold partitions in RAM