Maximum row size

Discussion in 'SQL Server' started by Sugsy, Aug 27, 2008.

  1. Sugsy

    Sugsy New Member

    Aug 27, 2008
    Likes Received:
    Trophy Points:
    Please can someone tell me how I can find the maximum row size for a table in SQL Server 2000.

    We've recently had issues with lack of space and drive on which data files reside is badly fragmented.

    Was wondering if this fragging occurred because row sizes were exceeding the 8KB that allows them to fit into a page.

    If anyone could give me some info on this topic & show me how to find Max row size would be very grateful.


Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice