How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What command do we use to rename a db?
What is difference between order by and group by?
Which is better statement or preparedstatement?
What are orphan records?
Explain the concept of view and Types of views in SQL server?
What is the difference between ddl and dml?
Is truncate a dml command?
Can you type more than one query in the query editor screen at the same time?
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
How to execute stored procedure and set temp table in sql server?
How to find the version of sql server? : sql server database administration
Do you know what is a with(nolock)?