Removing an extra TempDB file gave me Error Msg 5042: the file ‘tempdev02’ cannot be removed because it is not empty. Here is how I got rid of it.
SQL SERVER – How to Start SQL Server Service Without tempdb?
During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
Interview Question of the Week #048 – How to Move TempDB to Another Drive?
Can TempDB be moved to a different drive? Yes. Here are two reasons to do it and the exact steps to move TempDB to another drive.
SQL SERVER – New features in SQL Server 2016 Setup Wizard
Microsoft listened to feedback, and the SQL Server 2016 Setup Wizard shows it. Here are the new options I noticed, such as Perform Volume Maintenance Task.
Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Here is one of the important interview question which is related to TempDB and how to Move TempDB from One Drive to Another Drive When Low Disk Space.
Interview Question of the Week #015 – How to Move TempDB to Different Drive
How do you move TempDB to a different drive when its log file fills up or for better performance? Here is the simple script and the steps.