Relative Content

Tag Archive for sqlsql-serveroptimizationtime

Temporary tables vs table variables

Temporary tables store on disk and table variables – in memory. This means that write to temp table should be significantly slower when I insert let’s say one thousand guids. However when I checked two below scripts, it turned out that the time is almost identical 877/896. Why is that?