OLDCHAPPY (12/10/2013)
planning to leave about 10% free space so will check that it covers the space for index rebuilds. thanks to note that!
Free space in the data file should be about the size of the largest index. In simple or bulk-logged recovery, the log space needed is less than the size of the index, much less.
You're breaking the log chain to do this, is that a good idea?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability