NOCACHE equivalent ?

• Shivsam

  Old Hand

  Points: 330

  More actions

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• win

  SSCommitted

  Points: 1569

  More actions

  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