bas de zwart (12/10/2010)
GilaMonster (12/10/2010)
bas de zwart (12/10/2010)
Now I could leave the DB running the rest of the month with 65% free space but that wouldn't be very effective in terms of fragmentation and ad-hoc query performanceFree space in a database affects neither query performance nor fragmentation.
Perhaps not on the SQL server level, but surely on the OS level it does?
Only in the sense of inefficient use of hard drive space and maybe file-level fragmentation (which shrink-grow cycles do tend to cause more than just grow and leave does)
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