Hello all!
Is there any possibility to enumerate the in memory tables created in a specific database in sql server, i mean tables which name starts as "##.....".
Thank you very much.
brgds,
Teixeira
Printable View
Hello all!
Is there any possibility to enumerate the in memory tables created in a specific database in sql server, i mean tables which name starts as "##.....".
Thank you very much.
brgds,
Teixeira
You can't pin the table in memory anymore on sql server, but it'll stay in memory if been read constantly and sql has enough memory to work with.
bad news for what i wanted to do :(
Thanks,
brds
Teixeira
In SQL Server 2005 you can't pin the table.
DBCC pintable does nothing