Which command using Query Analyzer will give you the version of SQL server and operating system?
3 14452
How to install sql server 2005 express edition?
Explain transaction server auto commit?
What are truncate options available in sql server? : sql server database administration
Can we use where clause with group by?
How do we synchronize On-Premise SQL server with SQL Azure?
List some of the rules that apply to creating and using a ‘view’
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is inner join in sql server joins?
What is Replication?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Tell me about the approaches which you used to counter the DI problems.
what is a correlated sub-query? : Sql server database administration
Explain what is use of dbcc commands?
What are the diifferences between the ms sql server vs mysql?
What are the steps you can take to avoid “deadlocks”?