Post reply

NOCACHE equivalent ?

  • October 27, 2004 at 5:53 am

    #60340

    Hi,

    Oracle query :

    create table test(sno int, sno1 int) NOCACHE

    Is there any equivalent in SQL Server for the above (specifically for the NOCAHE syntax)

    Please advice,

    Thanks,

    ShivSam

  • October 28, 2004 at 1:48 am

    #528258

    AFAIK has nocache something to do with generating sequences. So my best bet would be, there is no direct equivalent. However, something like the IDENTITY function might prove useful at times. Here's is maybe also interesting link about migrating Oracle to SQL Server:

    http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 28, 2004 at 7:36 pm

    #528357

    You can do the opposite (cache) and keep the table in the database buffer cache with dbcc pintable, but I am not aware of a nocache equivalent.

     

    Win

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply