开发者

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 - ...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜