Loading ...
Sorry, an error occurred while loading the content.

1427File - maximum sizes of various objects defined in SQL Server 2008.htm

Expand Messages
  • knowsql2008@yahoogroups.com
    Mar 1, 2014
    • 0 Attachment

      Maximum Capacity Specifications for SQL Server 2008

      The following table specifies the maximum sizes and numbers of various objects defined in SQL Server 2008 databases or referenced in Transact-SQL statements.

      SQL Server Database Engine object

      Maximum sizes/numbers SQL Server (32-bit)

      Maximum sizes/numbers SQL Server (64-bit)

      Batch size

      65,536 Network Packet Size

      65,536 Network Packet Size

      Bytes per short string column

      8,000

      8,000

      Bytes per GROUP BY, ORDER BY

      8,060

      8,060

      Bytes per index key

      900

      900

      Bytes per foreign key

      900

      900

      Bytes per primary key

      900

      900

      Bytes per row

      8,060

      8,060

      Bytes in source text of a stored procedure

      Lesser of batch size or 250 MB

      Lesser of batch size or 250 MB

      Bytes per varchar(max), varbinary(max), xml, text, or image column

      2^31-1

      2^31-1

      Characters per ntext or nvarchar(max) column

      2^30-1

      2^30-1

      Clustered indexes per table

      1

      1

      Columns in GROUP BY, ORDER BY

      Limited only by number of bytes

      Limited only by number of bytes

      Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement

      10

      10

      Columns per index key

      16

      16

      Columns per foreign key

      16

      16

      Columns per primary key

      16

      16

      Columns per nonwide table

      1,024

      1,024

      Columns per wide table

      30,000

      30,000

      Columns per SELECT statement

      4,096

      4,096

      Columns per INSERT statement

      4096

      4096

    • Show all 50 messages in this topic