Post reply

identify fragmentation

  • October 15, 2008 at 5:21 am

    #199778

    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

  • October 15, 2008 at 5:51 am

    #885129

    Check the following links

    http://www.mssqltips.com/tip.asp?tip=1014

    http://www.mssqltips.com/tip.asp?tip=1165

  • October 15, 2008 at 6:49 am

    #885164

    Thank you

    That's exactly what I was looking for

  • October 16, 2008 at 2:43 am

    #885686

    though, is there a ROWID function in Sql Server?

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

  • October 16, 2008 at 2:49 am

    #885687

    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