Explain primary key in sql server?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
What is tempdb database? : SQL Server Architecture
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is transaction server auto commit?
What is difference between stored procedure and user defined function?
What is difference between commit and rollback when used in transactions?
What is the difference between clustered and non-clustered indexes in ms sql server?
Can you explain different types of locks in sql server?
What is collation sensitivity?
Determine when an index is appropriate?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is difference between table aliases and column aliases? Do they affect performance?