Explain about integration services of Microsoft SQL server?
How do clustered indexes store data?
Define tool Manage Statistics in SQL Server 2000 query ?
Explain what is raid and what are different types of raid levels?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Differentiate between a primary key and a unique key.
What is advantage data architect?
Explain filtered indexes?
Explain where clause?
Explain system scalar functions?
How to use old values to define new values in update statements in ms sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What method is used by the Command classes to execute SQL statements that return single values?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
what is a mixed extent? : Sql server administration