whole table in memory SQL Server
I want to know the memory开发者_运维问答 location of my table in SQL,
- Is it possible to know where is it stored the table or all the registries?
It is not possible.
Micro managing SQL Server to this extent would be a very bad idea. It is also not very useful information to have - what would you do with it?
Not. At. All.
SQL Server is a database engine that manages this for you.
It's quite unbelievable arrogance if you think you can do it better than the SQL Server team
There are other more practical reasons (first thoughts) - Internal structures change between service packs - Transaction logging of any INSERT - ...
精彩评论