Saturday, January 5, 2008

SQL Server Interview Questions

Explain Third normalization form with an example?
When you should use low fill factor?
How you can minimize the deadlock situation?
How to choose between a Clustered Index and a Non-Clustered Index?
Why there is a performance difference between two similar queries that uses UNION and UNION ALL?
Write a SQL Query to find first day of month?
A user is a member of Public role and Sales role. Public role has the permission to select on all the table, and Sales role, which doesnt have a select permission on some of the tables. Will that user be able to select from all tables ?
If a user doesnt have a permission on a table, but he has permission to a view created on it, will he be able to view the data in table?
Describe Application Role and explain a scenario when you will use it?
Both a UNIQUE constraint and a PRIMARY KEY constraint enforce uniqueness, so when you should use UNIQUE Constraint?
What is the difference between the REPEATABLE READ and SERIALIZE isolation levels?
Why one should not prefix user stored procedures with sp_?
You have several tables, and they are joined together for querying. They have clustered indexes and non clustered indexes. To optimize the performance how you will distribute the tables and their indexes on different file Groups?
Which event (Check constraints, Foreign Key, Rule, trigger, Primary key check) will be performed last for integrity check ?
After removing a table from database, what other related objects have to be dropped explicitly ?
How can you get an identity value inside a trigger, there are different ways to get identity value, explain why you will prefer one on another.
How to find out which stored procedure is recompiling?
How to stop stored procedures from recompiling?
When should one use instead of Trigger?
What is a derived table?

No comments: