Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
40 Cards in this Set
- Front
- Back
|
Objects in a database
|
2,147,483,647
|
|
|
Bytes per short string column
|
8,000
|
|
|
Bytes per text, ntext, or image column
|
2 GB-2
|
|
|
Bytes per index
|
900
|
|
|
Bytes per foreign key
|
900
|
|
|
Bytes per primary key
|
900
|
|
|
Bytes per row
|
8,060
|
|
|
Bytes in source text of a stored procedure
|
Lesser of batch size or 250 MB
|
|
|
Clustered indexes per table
|
1
|
|
|
Columns per index
|
16
|
|
|
Columns per foreign key
|
16
|
|
|
Columns per primary key
|
16
|
|
|
Columns per base table
|
1,024
|
|
|
Columns per SELECT statement
|
4,096
|
|
|
Columns per INSERT statement
|
1,024
|
|
|
Connections per client
|
Maximum value of configured connections
|
|
|
Database size
|
1,048,516 TB
|
|
|
Databases per instance of SQL Server
|
32,767
|
|
|
Filegroups per database
|
256
|
|
|
Files per database
|
32,767
|
|
|
File size (data)
|
32 TB
|
|
|
File size (log)
|
32 TB
|
|
|
Foreign key table references per table
|
253
|
|
|
Identifier length (in characters)
|
128
|
|
|
Instances per computer
|
16
|
|
|
Length of a string containing SQL statements (batch size)
|
65,536 * Network packet size
|
|
|
Locks per connection
|
Max. locks per server
|
|
|
Locks per instance of SQL Server
|
2,147,483,647 (static)
|
|
|
Nested stored procedure levels
|
32
|
|
|
Nested subqueries
|
32
|
|
|
Nested trigger levels
|
32
|
|
|
Nonclustered indexes per table
|
249
|
|
|
Objects concurrently open in an instance of SQL Server4
|
2,147,483,647 (or available memory)
|
|
|
Parameters per stored procedure
|
1,024
|
|
|
REFERENCES per table
|
253
|
|
|
Rows per table
|
Limited by available storage
|
|
|
Tables per database
|
Limited by number of objects in a database
|
|
|
Tables per SELECT statement
|
256
|
|
|
Triggers per table
|
Limited by number of objects in a database
|
|
|
UNIQUE indexes or constraints per table
|
249 nonclustered and 1 clustered
|
