Tag: SORT_IN_TEMPDB

SQL Server

Tips for using tempdb database in SQL Server 2016

Tips for using tempdb database in SQL Server 2016 Use TempDB section of SQL Server Installation Wizard. SQL Server 2016 introduces the new UI input control on the Database Engine Configuration – TempDB section of SQL Server Installation Wizard. Now during setup, you can configure the number of tempdb database files, initial size, autogrowth and directory placement. You can specify […]