appple (8/11/2010)
I done Rebuild On Non clustered Index,before rebuild on my index, framentation percentage is 80%,
after rebuilding indxes it is showing me same percentage,
Can Please Suggest me on this......:-)
rebuild doesnt work well for small table( less than 1000 data pages)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)