⟩ Why are the integrity constraints preferred to database triggers?
Because it is easier to define an integrity constraint than a database trigger.
Because it is easier to define an integrity constraint than a database trigger.
Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?
Do you know what is the importance of a recovery model?
Tell us how do you trace the traffic hitting a SQL Server?
Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?
Tell us what is a system database and what is a user database?
Tell me how would you handle data loss during a database migration?
Tell us when setting Replication, is it possible to have a Publisher as 64 Bit SQL Server and Distributor or Subscribers as a 32 Bit SQL Server?
Can you list out various services which are important for SQL Server and its components functionality?
Tell us which are third-party tools used in SQL Server and why would you use them?