| Login

Search this Blog

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.
Jul3

Written by:R Teachout
7/3/2008 1:23 AM 

Ever wonder how to put a mssql table into RAM after it has been read?

If you can spare some some memory, you can pin a table into memory, so that the pages of this table remain in memory, once read into memory. This is only okay with smaller tables, but do not try this with larger tables as that can negatively impact SQL Server performance.

The following command can be used to pin a table in memory
( see DBCC PINTABLE )

EXEC sp_tableoption 'TableNameHere', 'pintable', 'true'
GO 

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment  Cancel 


-BrainyQuote.com

Inspired by Nina