I had a great time speaking at the San Diego SQL User Group - SQL Server with Mr. Denny
Home > IT Blogs > SQL Server with Mr. Denny > I had a great time speaking at the San Diego SQL User Group
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

« Remote Desktop, it’s better than ever
Back To Basics: The INSERT Statement »
Mar 21 2008   6:11AM GMT

I had a great time speaking at the San Diego SQL User Group



Posted by: mrdenny
Service Broker, In Person Events, Query tuning

I’d like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my SQL Server Query Tuning and SQL Server Service Broker presentations.  You can grab the slide deck and sample code from those two links.

 I was happy to fill in on short notice for them when there scheduled speak cancelled on them.  Hopefully the members liked the presentations as much as I liked giving them.  Hopefully the San Diego SQL Server User Group will invite me back in the future.

Denny

AddThis Social Bookmark Button     Comment     RSS Feed     Email a friend

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

Cr8nk  |   Mar 21 2008   5:26PM GMT

Hi Denny,

Thanks for the great presentation last night. Just a follow up to the service broker discussion. One of the questions I asked was about balancing creating dialogs vs the amount of messages you send. Just wondering if you have seen this post which talks about the overhead of creating conversations.

 <a href="http://blogs.msdn.com/rogerwolterblog/archive/2006/05/20/602938.aspx" title="http://blogs.msdn.com/rogerwolterblog/archive/2006/05/20/602938.aspx" target="_blank">http://blogs.msdn.com/rogerwolterblog/ar…</a>


 

Mrdenny  |   Mar 28 2008   5:31PM GMT

I hadn’t seen this specific post before, and the poster does have some interesting techniques that do appear to need to be looked into more. I would be careful however because keeping the dialog open keeps message information about each message in the system so that the service broker can ensure that the same message isn’t send on the same dialog a second time. I could see this having a performance problem and potentially a storage problem depending on how much data is kept around in the database for a received message on an open conversation.