Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/40

Click to flip

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