IndexDefrag And Shrink | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

IndexDefrag And Shrink

Hi , Do the IndexDefrag truncate the unused space of the page ? Or need to shrink the db after perform the IndexDefrag command ? Thanks ,
Travis
No it will not and in order to truncate the space only TRUNCATE statement or SHRINK operation will take care. You will be wasting system resources if you perform a defrag and doing a shrink operatons, why not set a size to transaction log in order to continue the weekly defrag without any issues. Fyihttp://sqlserver-qa.net/blogs/tools…server-index-optimization-best-practices.aspx on the best practices Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>