Caveman's Blog

My commitment to learning.

SQL Server: Maximum number of indexes per table

leave a comment »


One of the favorite questions in a technical interviews seems to be: What is the maximum number of indexes for a table in the SQL Server database? Following is a breakdown of the maximum number of indexes by different versions of SQL Server. I am yet to come across a scenario when a table needed to have huge number of indexes like mentioned in the listing below.

Maximum Sizes
Object SQL Server 7.0 SQL Server 2000 SQL Server 2005 SQL Server 2008
Clustered Index 1 1 1 1
Non-clustered Index 249 249 249 999

References:

1. Maximum Capacity Specifications
2. Maximum Capacity Specifications for SQL Server 2005
3. Maximum Capacity Specifications for SQL Server

Advertisements

Written by coolgirlsblog

March 25, 2011 at 4:18 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: