Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Location
    Jersey City
    Posts
    2

    Unanswered:

    Hi,
    Can you please let me know of the sybase command which can be used to find the max size of a row?
    Cheers.

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    dbcc traceon(3604)
    go
    dbcc serverlimits
    go


    should give you information about all sorts of limits for your server.

    Michael

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    To see the row length for a table
    Code:
    select maxlen
    from sysindexes
    where id = object_id("tablename") 
      and indid in (0,1)
    To read more about space overheads see
    Petrformance and Tuning: Basics
    Chapter 8: Data Storage
    Number of columns and size

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •