identify fragmentation

  • Hi

    How do you identify fragmentation in Sql Server?

    I read that you could select all the ROWIDs and look at their page-number.But I didn't find anything like ROWID in Sql Server.Or is there another method?

    Thank you

  • Thank you

    That's exactly what I was looking for

  • though, is there a ROWID function in Sql Server?

    Some say that this is very usefull (in oracle or others..)

  • though, is there a ROWID function in Sql Server?

    Not directly, no. The closest is the identity column and the ROW_NUMBER function, though neither is a direct replacement.

    You can't easily get at a row's physical location. (page or slot) and you shouldn't need to. Besides, they can change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

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