⟩ What is the difference between file server and a database server?
A file server just transfers all the data requested by all its client and the client processes the data while a database server runs the query and sends only the query output.
A file server just transfers all the data requested by all its client and the client processes the data while a database server runs the query and sends only the query output.
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?
Tell me why should I go to all the trouble of creating a database when I have a perfectly good Excel Spreadsheet?
Do you know what is DCL?
Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
Tell us how can you control the amount of free space in your index pages?
Tell us what are the different Topologies in which Replication can be configured?
Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode?