• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendices > SQL Server/MSDE Specifications

Appendix C. SQL Server/MSDE Specifications

Table C-1. SQL Server 7 and SQL Server 2000 Specifications
Specifications SQL Server 7 SQL Server 2000
Bytes per column of data types varchar or nvarchar 8000 8000
Bytes per column of data types text, ntext, or image approximately 2 GB approximately 2 GB
Bytes per GROUP BY, ORDER BY 8060 8060*
Bytes per index 900 900**
Bytes per foreign key 900 900
Bytes per primary key 900 900
Bytes per row 8060 8060
Grouped indexes per table 1 1
Nongrouped indexes per table 249 249
Columns per index 16 16
Columns per primary key 16 16
Columns per foreign key 16 16
Columns per base table 1024 1024
Columns per SELECT statement 4096 4096
Columns per INSERT statement 1024 1024
Database size 1,048,516 TB; 2 GB for MSDE 1,048,516 TB; 2 GB for MSDE
Databases per SQL Server (with SQL Server 2000 per instance) 32,767 32,767
Instances per computer Not possible 16
File groups per database 256 256
Files per database 32,767 32,767
File size of a data file 32 TB 32 TB
File size of a log file 4 TB 32 TB
Nesting levels of stored procedures 32 32
Nested subqueries 32 32
Nesting levels for triggers 32 32
Parameters per stored procedure 1024 1024
Tables per SELECT statement 256 256


* There is no limit to the number of items, but there is a limit of 8060 bytes for the row size of intermediate worktables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint