Results 1 to 4 of 4

Thread: In memopry Tables in sql server

  1. 07-07-2008, 12:16 PM #1
    teixeira
    teixeira is offline Registered User
    Join Date
    May 2006
    Posts
    13

    In memopry Tables in sql server

    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
    Reply With Quote Reply With Quote
  2. 07-07-2008, 12:21 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    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.
    Reply With Quote Reply With Quote
  3. 07-07-2008, 01:19 PM #3
    teixeira
    teixeira is offline Registered User
    Join Date
    May 2006
    Posts
    13
    bad news for what i wanted to do

    Thanks,
    brds
    Teixeira
    Reply With Quote Reply With Quote
  4. 07-15-2008, 11:30 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    In SQL Server 2005 you can't pin the table.

    DBCC pintable does nothing
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules