What is SQL Server?
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.
SQL Server works exclusively on the Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 that ran on both Windows and Linux.
SQL Server consists of two main components:
- Database Engine
- SQLOS
The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, indexes, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Engine.
The Relational Engine contains the components that determine the best way to execute a query. The relational engine is also known as the query processor.
The relational engine requests data from the storage engine based on the input query and processed the results.
SQLOS
provides many operating system services such as memory and I/O management. Other services include exception handling and synchronization services.
Order Of Query Execution
