SQL Server Performance

Viewing Data Page

Discussion in 'General Developer Questions' started by amitm79, Jan 27, 2005.

  1. amitm79 New Member

    Hi All,
    A slightly weird question but is there any way i can see how data is organized in the data page for a particular table i.e. is there any system stored procedure which can help me look at the data file itself. The curiosity arose from the fact that decreasing a few columns in the table has given me significant change in the space being used for the table (more then theoretically calcuating the effect from column sizes). Any help/experience/link is welcome.

    Regards,
    Amit
  2. satya Moderator

Share This Page