All,
I have a sql 2000 database with the latest service pack, and it has 9 .ndf files.
The defragmention level is 33 % on average for more than half of the tables in that database. And the number of rows modified since the last run of the optmization job is 0 for most of them but even then the fragmentation level is 33 %.
Is this because we are using lot of ndf files ? or it is because lots of rows are being changed every day ?
Thanks.