What are different types of replication in sql server?
what r steps to we need to fallow b4 kill the process?
What are the types of database recovery models?
How do I edit a stored procedure in sql server?
What are xml indexes?
What is a non equi join?
What is read committed?
How many clustered indexes there can be on table ?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Define compound operators?
Explain what is public role in sql server?
How can I know what locks are running on which resource?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration