What are the instances when triggers are appropriate?

979

What is the difference between lock, block and deadlock? : sql server database administration

1040

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

878

What do you understand by replication in sql server? Mention the different types of replication in sql server.

940

What are the restrictions that views have to follow? : SQL Server Architecture

995

What is ms sql server index?

1096

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5921

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

999

What are the basic functions for master, msdb, model, tempdb databases?

1036

how to do partition in sqlserver

2468

What are types of subqueries?

1062

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

975

What is merge statement?

1076

What is the new security features added in sql server 2014? : sql server security

996

What is the beast way to write CTE in SQL Server ?

1039