[dineeshd]

Description: If you are having the habit of extensive use of TEMP tables, which will leave free spaces or white spaces in your database, this code will help you remove those free spaces.This piece of code will shrink the database physical files, so that some disk space can be freed up.

backup log Northwind with truncate_only
go
dbcc shrinkfile(Northwind) -- Logical file name of Master File
go
dbcc shrinkfile(Northwind_log) -- Logical file name of Log File
go