Maximum number of Index per table

For SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx


For SQL Server 2008:
1 Clustered Index + 999 Nonclustered Index = 1000 Index
http://msdn.microsoft.com/en-us/library/ms143432.aspx


Reference: http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/

What is Normalization?

• It is a process of efficiently organize the data in Database
• Normalization is Invented by Edgar Frank "Ted" Codd

Main goals of Normalization:

• Eliminate redundant Data
• Ensure Data Dependencies make sense

Advantages of Normalization:

• Reduce the Space consumption
• Ensure Data is logically stored

Types of Normal Forms:

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Norm (3NF)
• Boyce-Codd Normal Form (BCNF)
• Forth Normal Form (4NF)
• Fifth Normal Form (5NF)
• Domain/Key Normal Form (DKNF)
• Sixth Normal Form (6NF)