Home Forums SQL Server 2008 SQL Server 2008 Administration Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again?? RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

  • When someone writing about SQL server says "Never do this: <insert action here>!" it is almost never 100 percent true. For every action you can do, there exists a set of circumstances that call for it. You just need to understand when you are actually in the sitation that calls for that action, what the ramifications are, and how to mitigate the effects of that action.