Thanks steve for the info...With God's grace I cd still get a backup from a test server and able to get all my OLAP back up running...I tool over this...
That was very informative reply from you. Yes, many times the FTI gets corrputed. But then whenever I try to rebuild, it consumes a lot of time and sometimes...
I carried out another round of testing with the same test table at offshore. Here are the steps I performed and results I got. Whereas DBCC CLEANTABLE...
Thanks for your reply. The fill factor was 70 at the initial stage itself. what I feel is that(sounding paranoid) ...is it the same way that we delete...