SQL Server is defacto database standard microsoft .net plateforms. Whenever you go as a .net developer. You have to get knowledge of the sql server.
I have found a very good link of sql server interview quesiton. Which will help you to prepare for interview.
here is the link :