Professional Web Applications Themes

Row size limit (8060) calculation - Microsoft SQL / MS SQL Server

Each row for a table in SQL server can hold up to 8060 bytes data. A client give me a list of columns with all definitions, I need to create a table by CREATE TABLE statement. CREATE TABLE statement may fail with a message indicating I am over its 8060 byte row size limit. Assume all the columns does not have varchar data type, does anyone know how I can calculate the # of bytes so that if it reached 8060 before I issue CREATE TABLE statement? Thank you....

  1. #1

    Default Row size limit (8060) calculation

    Each row for a table in SQL server can hold up to 8060
    bytes data.

    A client give me a list of columns with all definitions, I
    need to create a table by CREATE TABLE statement. CREATE
    TABLE statement may fail with a message indicating I am
    over its 8060 byte row size limit.

    Assume all the columns does not have varchar data type,
    does anyone know how I can calculate the # of bytes so
    that if it reached 8060 before I issue CREATE TABLE
    statement?

    Thank you.


    Peter Guest

  2. #2

    Default Re: Row size limit (8060) calculation

    See estimating table size <createdb.chm::/cm_8_des_02_92k3.htm> in the
    SQL Server 2000 Books Online.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "Peter" <peter.zhangnoetix.com> wrote in message
    news:561101c341cb$612afe80$a401280aphx.gbl...
    > Each row for a table in SQL server can hold up to 8060
    > bytes data.
    >
    > A client give me a list of columns with all definitions, I
    > need to create a table by CREATE TABLE statement. CREATE
    > TABLE statement may fail with a message indicating I am
    > over its 8060 byte row size limit.
    >
    > Assume all the columns does not have varchar data type,
    > does anyone know how I can calculate the # of bytes so
    > that if it reached 8060 before I issue CREATE TABLE
    > statement?
    >
    > Thank you.
    >
    >

    Dan Guzman Guest

Similar Threads

  1. Form size limit?
    By Vidikron in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: March 11th, 03:21 PM
  2. About the polygon limit size
    By Newt99 in forum Macromedia Director 3D
    Replies: 0
    Last Post: April 14th, 12:46 PM
  3. CF7 PDF Size Limit
    By CFLett in forum Macromedia ColdFusion
    Replies: 0
    Last Post: March 7th, 06:43 PM
  4. limit directory size
    By Jörg Kleimann in forum Linux / Unix Administration
    Replies: 3
    Last Post: November 18th, 04:20 PM
  5. hdisk size limit?
    By Dan Million in forum AIX
    Replies: 0
    Last Post: September 10th, 11:21 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139