I am doing some R&D on Indexes.
I have a table as follows:
CREATE TABLE SINGLEINTVARCHAR
ID INT IDENTITY(1,1) PRIMARY KEY
and i have inserted records 1790.
Now when i check the fragmentation of clustered index it is showing 50 so i have applied the REBUILD option but still it is showing 50 percent only.
Can any one tell me why i am not able to reduce this fragmentation level?