Minimize the size of tempdb in SQL Server

(Arthur Fuller) SQL Server automatically creates a database called tempdb for use as a workspace. When you specifically create a temporary table within a stored procedure, for example (CREATE TABLE #MyTemp), the SQL engine creates it in tempdb regardless of which database you are actually using. In

Read More - Register for Free Membership