Best practices for developing customizations for Microsoft ...

The process can run on the client tier or the server tier. The objects are held in memory until the size reaches 128 KB. The dataset is then written to a disk file on the server tier. You can use InMemory temporary tables when the amount of data is small and Microsoft SQL Server round trips should be … ................
................