Temp table(#): Will live in memory until user is active or connected Global Temp table(##): Will live in memory until all users are connected to SQL Server.