Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

cache,cpu,databases,indexes,huge - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » cache » cpu » databases » indexes » huge (RSS)

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...