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.
Blog post link for the video with script
http://sqlage.blogspot.com/2015/04/ho...
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12...
On this page of the site you can watch the video online SQL Server DBA Tutorial 46-How to Reduce TempDB Size without Restarting SQL Server Services with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 15 April 2015, share the link with friends and acquaintances, this video has already been watched 56,684 times on youtube and it was liked by 232 viewers. Enjoy your viewing!