pintable

1, DBCC PINTABLE Marks a table to be pinned, which means Microsoft SQL Server does not flush the pages for the table from memory.

将SQL Server数据表驻留内存是SQL Server提供的一项功，在一般小型系统的开发过程很少会涉及到。

In this model, every PC machine may logout at any time and thus may result in pintable, so the model must be adjusted by itself instantly to adapter itself to the changes.

由于P2P传模型，任何PC机都有可退出，容易造成系统的不稳定。