Memory Table vs Temporary Table

• dusang

  SSC Enthusiast

  Points: 164

  More actions

  May 13, 2003 at 2:37 pm

  #81904

  Just wondering if there is any difference (performance or so) between memory table and temporary table when used in stored procedure...

  -- Memory Table

  Declare @MemoryTable table

  (

  ID int identity,

  SomeText varchar(20)

  )

  INSERT INTO @MemoryTable VALUES ('mem')

  SELECT * FROM @MemoryTable

  -- Temporary Table

  CREATE TABLE #TemporaryTable

  (

  ID int identity,

  SomeText varchar(20)

  )

  INSERT INTO #TemporaryTable VALUES ('tmp')

  SELECT * FROM #TemporaryTable

  dusan

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  May 13, 2003 at 6:08 pm

  #457048

  Just wondering if memory table exceed available memory will SQL / Windows start paging or create a temp table underhood.

  I think there was a previous post saying it's very similar.