SQL Server Temp Table vs Table Variable

http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server/16386#16386

* The author use “sys.fn_PhysLocFormatter(%%physloc%%)” to show the storage location. It is not 100% correct. The file id is the file id relative to the database id. Even the data are eventually stored in tempdb, the file id’s have different meaning.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s