Tell me about the approaches which you used to counter the DI problems.
can an order by clause be used in a creation of a view?
What command is used to create a database in the sql server and how?
What is a filestream?
Can a unique index be created on a column, which contains null?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is transactional replication?
Differentiate between SQL and ORACLE joins and write their syntax.
Tell me when is the update_statistics command used?
What is a transact-sql statement batch in ms sql server?
How do I shrink an ldf file?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How will you hide an attribute? : sql server analysis services, ssas
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is collation?