What are the instances when triggers are appropriate?
What is the difference between lock, block and deadlock? : sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What are the restrictions that views have to follow? : SQL Server Architecture
What is ms sql server index?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the basic functions for master, msdb, model, tempdb databases?
how to do partition in sqlserver
What are types of subqueries?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is merge statement?
What is the new security features added in sql server 2014? : sql server security
What is the beast way to write CTE in SQL Server ?