SQL Database Concepts Question:
Download Questions PDF

Do you know what is SQL service broker?

Answer:

Service Broker allows internal and external processes to send and receive guaranteed, asynchronous messaging. Messages can also be sent to remote servers hosting databases as well. The concept of queues is used by the broker to put a message in a queue and continue with other applications asynchronously. This enables client applications to process messages at their leisure without blocking the broker. Service Broker uses the concepts of message ordering, coordination, multithreading and receiver management to solve some major message queuing problems. It allows for loosely coupled services, for database applications.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what is DBCC?Tell me what is difference between View and Materialized view?