Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is a covered index?
You want to implement the one-to-many relationship while designing tables. How would you do it?
where can you add custom error messages to sql server? : Sql server administration
Explain boyce and codd normal form(bcnf)?
what is the Enterprise manager(2000) and management studio (2005)?
How to receive returning result from a query?
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
What are the common performance issues in sql server?
How does normalization work?
How can you insert null values in a column while inserting the data?
What are the types of database recovery models?
Can a synonym name of a table be used instead of a table name in a select statement?