⟩ What are the various uses of database triggers?
Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.
Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.
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?
Explain me what types of replication are supported in SQL Server?
Tell us what are the High-Availability solutions in SQL Server and differentiate them briefly?
Suppose you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?