What is the server name for sql management studio?

976

What are the difference between primary key and unique key? : sql server database administration

917

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

862

What is the main purpose of having conversation group?

859

What is the log shipping?

967

What are recommended options to be used while using db mirroring? : sql server database administration

1096

what is nonclustered index

911

What is conditional split?

1022

What is for xml in sql server?

1006

How can we delete Duplicate row in table?

1018

What is the name of the system variable that returns the number of rows affected by a SQL statement?

982

what are the different types of replication you can set up in sql server? : Sql server database administration

991

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1022

Can you explain the disadvantages/limitation of the cursor?

935

Why use triggers?

981