⟩ What are the disadvantages of the client/server model?
Heterogeneity of the system results in reduced reliablity. May not be suitable for all applications. Managing and tuning networks becomes difficult.
Heterogeneity of the system results in reduced reliablity. May not be suitable for all applications. Managing and tuning networks becomes difficult.
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?
Tell me what is the difference between dropping a database and taking a database offline?