Whew!!!!!!!

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...

Hey John,

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...

IS DBCC CLEANTABLE REALLY USELESS??

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...

Hey Chris !

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...