What is identity?
Can you please explain the difference between primary keys and foreign keys?
What is row-level compre?
What are the joins in sql server? : sql server database administration
Does partitioning ssd reduce performance?
How to provide default values to stored procedure parameters?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Where do you think the users names and passwords will be stored in sql server?
List all types of constraints in sql server?
Is foreign key a primary key?
What is difference between clustered and non clustered index?
Explain the microsoft sql server delete command? : SQL Server Architecture
Explain what is the difference between union and union all?