SQL server Rebuild Index
- by Uday
How can we know that before rebuilding index --How much space is required for the Transaction Log file( I knew we may required to consider sort_tempdb option , if we set to ON then we may required to ensure about tempdb space as well , Also if we set off then sorting, temporary indexes(during Build phase of rebuild index) creation will takes place in same Database.)?.
Usually I have checked with Many users they say :Log file size =1.5 * Index size.
How much space required for the Filegroup for datafiles-for ex-Consider I have one filegroup with 1 Mdf + ndf files.
I have MSDN Link :those are pretty good information about per-requisites before rebuild index
Link :http://msdn.microsoft.com/en-us/library/ms191183.aspx
How can I tell exactly or Approx... to get Log/Primary FG size(or any other filegroup).