Tips for using tempdb database in SQL Server 2019 Permit the tempdb database to automatically grow. Autogrow feature is set by default. Each time the SQL Server 2019 is started, tempdb database is recreated and reset to its default size. Automatically growing results in some performance degradation, therefore you should set a reasonable size for tempdb database and a reasonable...