(csomberg@dwr.com) writes:
> I'm doing some performance reviews and wish to know what tables SQL has
> pinned in memory and which ones have are loaded through usage ...
>
> Is there a way ?
SELECT * FROM sysobjects WHERE objectproperty(id, 'TableIsPinned') = 1
I completely share Gert-Jan's recommendation to stay away from DBCC
PINTABLE.
--
Erland Sommarskog, SQL Server MVP,
esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp