GilaMonster (1/31/2011)
Do you understand how SQL uses the buffer pool for data cache? Need to see where to start explanation from.Being in the buffer pool and being on disk are not mutually exclusive possibilities. Being in memory doesn't mean not allocated space in the DB and vis versa.
I think I know what you mean by "in the buffer pool' - it just means in memory, right? On the other hand, I don't know exactly how it is used.
It's true that data can be both in memory and written to the disk (so they're not mutually exclusive). But my understanding is that they can be in memory only (even if space is reserved for them, but the values themselves are in memory only). As for space allocation, I don't see how that has much bearing on the situation in this context if we're strictly speaking of the data itself.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking