Row size of the Table

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  March 28, 2012 at 2:41 am

  #266366

  Is there a way I can find out the row size fo a table ?

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 28, 2012 at 2:49 am

  #1465535

  This script might help

  http://www.sqlservercentral.com/scripts/Administration/61219/

  [font="Verdana"]Markus Bohse[/font]

• kutti609

  SSC Rookie

  Points: 29

  More actions

  March 28, 2012 at 7:26 am

  #1465654

  Sp_spaceused Table_Name

  Second column of the output will give you the number of Rows present in the table

  Regards,

  Kuttikrishnan.P

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  March 28, 2012 at 9:32 am

  #1465759

  sqlnaive (3/28/2012)

  ---

  Is there a way I can find out the row size fo a table ?

  1. Is the table a heap (no indexes) or does it contain indexes?

  2. Do you want to know the maximum size of a row, that is all columns containing data? And all columns such as char,varchar containing the maximum number of characters the column can contain?

  Here is a good source, which might assis you

  http://msdn.microsoft.com/en-us/library/ms189124(v=sql.100).aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]