Jayanth_Kurup (1/18/2013)
Am not sure if I am understanding the question right, there is autoincrement set to 1 MB for the database files. The files are located on indvigual disk drives. Wouldnt simply changing the file factor and rebuilding indexes be good enough the remove any fragmentation , probably shrinking the database too.
You're thinking of logical fragmentation. This is physical fragmentation, i.e. fragmentation of the mdf or ldf on the OS file system. No commands in SQL Server handle that directly. Shrinking the file may hep though in certain situations, but not likely in cases where multiple files existed and all started at a very small size and autogrew many times at 1MB each.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato