• I think you are inserting data into TableA which has a uniqueidentifier as the clustered index? That is source of your problem. The index fragmentation is going to be through the roof.

    How it can be index fragmentation ? it is uniqueidentifier right , we should not put cluster index to uniqueidentifier?

    for child tables it is non cluster-index only.