In this post, I am providing one T-SQL script which generates DBCC Shrinkfile for each database file of the SQL Server. You can also visit one of the related article: SQL Server: The TempDB is Full, Shrink it or Move it Generally, database administrator prefers to execute SHRINK when the database file is occupying more […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.