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.
]]>