Home Library Learn Samples Downloads Support Community Forums
1 out of 1 rated this helpful - Rate this topic

DBCC PINTABLE (Transact-SQL)

SQL Server 2005

Marks a table to be pinned. This means the SQL Server Database Engine does not flush the pages for the table from memory.

ms178015.note(en-US,SQL.90).gifImportant:
This functionality was introduced for performance in SQL Server version 6.5. DBCC PINTABLE has highly unwanted side-effects. These include the potential to damage the buffer pool. DBCC PINTABLE is not required and has been removed to prevent additional problems. The syntax for this command still works but does not affect the server.

DBCC PINTABLE returns this result set (message):

Copy 
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.