GilaMonster (11/5/2012)
sanket kokane (11/5/2012)
also as per the above person said never shrink your data file,it makes your indexes completely unusedNo, it does not. It fragments indexes, doesn't make them unusable, doesn't make SQL scan more or seek less or anything like that.
Point Noted 🙂
also couple of good links ,not to shrink your data files
http://www.sqlskills.com/blogs/paul/post/why-you-should-not-shrink-your-data-files.aspx
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/
-----------------------------------------------------------------------------
संकेत कोकणे