The Storage Engine and Query Processor are both important core part of SQL Server. Storage Engine is responsible for data integrity and data storage in disk / memory while the Query Processor simply process the query bases on execution plan and return the result. Most of the interviewer asks this question to SQL Server DBA … Continue reading SQL Server Interview: How internally it executes a SQL Statement?