SQL Server Service Processes | Dataford Interview Questions

What are the main SQL Server services (processes), and what does each one do at a high level?

Use the supplied service catalog to identify core SQL Server services and combine their responsibility statements. Include only core services and present the results in a stable, readable order.

Output

One row per core service with service_name, process_name, and high_level_role
Combine multiple responsibility statements into high_level_role, separated by semicolons
Order by display_order ascending

Schema

sql_server_services

Column	Type	Description
service_idPK	INT	Unique service identifier
service_name	VARCHAR(150)	SQL Server service name
process_name	VARCHAR(100)	Executable process associated with the service
is_core_service	BOOLEAN	Whether the service is considered a main SQL Server service
service_group	VARCHAR(80)	Functional grouping for the service
display_order	INT	Presentation order for the service

sql_server_service_responsibilities

Column	Type	Description
responsibility_idPK	INT	Unique responsibility identifier
service_id	INT	Referenced SQL Server service
responsibility	VARCHAR(300)	High-level responsibility statement
responsibility_order	INT	Order in which responsibility statements are combined

Your question is SQL Server Service Processes. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem