Tuesday, 15 February 2011

messaging - SQL Server Service Broker and batches -


Do I understand SQL Server (in this case 2008 R2) the message that the service broker only talks about words? In other words, if I have a query like this:

  announcement message message (handling UNIQUEIDENTIFIER, message_nhearar (MAX), message_type_name SYSNAME); Receive messages from the top 5 conversation_hands, message_boice, message_type_name. Select Mimease @ MissSews from Conversation_Handal, Message_by @ message  

If I'm from the same conversation then I'll get only five rows? At the moment I am sending a message to my messages at one time, but if there are ten such messages in the queue, they are giving only one at the same time.

receipt related only to a conversation group Will delete the messages. Unless you manage explicit conversation groups, each conversation is a single group. If you only send a message per conversation, you will only end up receive one message every time. It has been put in.

get is a great time to run, so you should generally group more messages together for high throughput.


No comments:

Post a Comment