Does the unique constraint create an index?
what are the advanced features in sql 2008?
How will you monitor replication latency in transactional replication? : sql server replication
What is a periodical index?
Explain how to maintain a fill factor in existing indexes?
How many levels of sp nesting is possible?
What are the different types of locks in the database?
What is the difference between insensitive and scroll cursor?
What is “asynchronous” communication in sql server service broker?
what is the information that can be stored inside a bit column? : Sql server database administration
what is bit datatype? : Sql server database administration
Explain the dirty pages?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?