Limitationen in Microsoft SQL Server
Limitationen in SQL Server 6.0
Limitationen in SQL Server 6.5
Limitationen in SQL Server 7.0
Limitationen in SQL Server 2000
Limitationen in SQL Server 6.0
Nachfolgend eine Liste der Limitationen und Spezifikationen.
| Merkmal | Spezifikation |
| Devices | 256 devices per SQL Server Maximum size for each logical device is 32 gigabyte (GB) Note: The maximum total addressable storage is 8 TB (256 devices * 32 GB maximum per device). |
| Databases | 32'767 databases The minimum database size is 1 megabyte (MB) The maximum database size is 1 terabyte (TB) Note: Each logical device can be a maximum of 32 GB and each database can have a maximum of 32 device fragments (32 GB * 32 = 1 TB). |
| Tables | 2 billion (2'147'483'647) tables per database The maximum number of bytes per row is 1'962 (exkluding text and image columns) The maximum table size is about 1 terabyte (TB) |
| Columns | 250 columns per table |
| Indexes | 1 clustered index per table 249 nonclustered indexes per table A composite index can have up to 16 columns |
| Triggers | Maximum of 3 triggers per table - one each for INSERT,
UPDATE and DELETE Triggers can have 16 levels of nesting |
| Stored procedures | A stored procedure can contain as many as 255 parameters and have up to 16 levels of nesting |
| User connections | 32'767 Note: MS SQL Workstation 6.0 has the same capabilities as MS SQL Server, except that it is a single-user licensed product that supports a maximum of 15 simultaneous database connections. |
| Open databases | 32'767 |
| Locks | 2 billion (2'147'483'647) |
| Open objects | 2 billion (2'147'483'647) |
Quelle: SQL Server Books Online, Administrator's Companion for SQL Server 6.0
Limitationen in SQL Server 6.5
Limitationen in SQL Server 7.0
Limitationen in SQL Server 2000
Haben Sie Fragen,
Anregungen oder einen Fehler entdeckt?
Kontakt zum Autor
Zuletzt aktualisiert am
20.07.2004 / 23:30 Uhr
Zuletzt kontrolliert am 22.12.2008 / 07:00 Uhr
© 2002-2009 by Philipp von Wartburg, Schweiz
Alle Rechte vorbehalten