How to Reduce TempDB Size without Restarting SQL Server Services - SQL Server DBA Tutorial

In this video you will learn how to reduce TempDB size without restarting SQL Server Services? Video explains couple ways to do it,
1- Using SQL Server Management Studio
2- Using T-Script
It also walks you through where these methods of reducing TempDB size might not work and best practices of shrinking TempDB Files.

Scripts:

USE [tempdb]
GO
--10 is desired size in MB, keep in mind that this size needs to be more than or equal to minimum required
--size of tempdb, otherwise tempdb will not shrink
DBCC SHRINKFILE (N'tempdev' , 10)
GO



Reduce TempDB Size without Restarting SQL Server Services - SQL Server DBA Tutorial