Identify fragmentation?

  • How can I identify any fragmented tables or indexes?

  • DBCC SHOWCONTIG

    It Will show you page density, extent switches and so on.

    refer it on BOL

    MW


    MW

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply