The other way to automate this stored procedure is by attaching it to the queue itself so that it Service Broker directly executes the procedure in a process called activation. With activation Service Broker starts an application whenever there is work to do (e.g. when messages are in the queue).
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced in SQL Server 2005, and if you ask me, is one of the most under-utilized, under-appreciated features in SQL Server.
The use of indexes in SQL Server can make or break a database application and in this webcast we will take a look at best practices to ensure you are properly using and maintaining indexes.
Fortified Data is a full-stack IT partner focused exclusively on data. While some companies sell you on hundreds of years of database experience, a cabinet full of awards, and a resume of skills, Fortified Data is driven by our passion to deliver you optimal results and increased capabilities to your organization.