I noticed that when I right click manually on an index and choose "Rebuild" or "Reorganize", its not giving any indication that its doing so, then I click on properties again for the same index, I see the fragmentation level is still at the same percentage even after refreshing!
Am I missing something?
I'm using the SQL Server 2008 R2 Standard edition
Thanks in advance
