Thursday, June 4, 2009

Different types of joins in SQL Server

INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN

Wednesday, June 3, 2009

Indexes retrieve the data quickly

There are two types of indexes in SQL Server.
Clustered index
Non Clustered index

Normalization is the first step for DB

First Normal Form

Second Normal form

Third normal form: