I faced SQL SERVER interview questions

1. Alternative key
2. Locks in sqlsever

3. Type of indexes?

4. Joins

5.  Partition in sqlsever

6. difference between 1 . varchar(8000) vs varchar(max)

                                        2. Sql Server 2005 vs 2008

                                         3. Delete vs Truncate

                                         4. Deterministic vs non-Deterministic functions

                                         5. Union vs Union all

                                         6. .mdf vs .ndf vs .ldf

                                         7.

7.Triggers

8.Snowflake schema