What are functions3 9109
how to get the automatic backup of the database in the sql server4 34122
Which command using Query Analyzer will give you the version of SQL server and operating system?3 14452
What is the STUFF function and how does it differ from the REPLACE function?2 19087
What is the purpose of UPDATE STATISTICS?2 11852
What is de-normalization and when do you do it?3 7232
Explain some DBCC commands?6 17511
What is the purpose of using COLLATE in a query?1 17733
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”?