Great going!!!

Congratulations and Best Wishes to Steve, SSC and RedGate...

Hi dphillips,

I appreciate your observation on the "nomenclature"! And as far as the article is concerned, thanks to Steve for his valuable comments.

Not sure why the approach is RBAR approach?...

Zanonil,

Can you elaborate more on CHECKSUM? An example would help.

Hi Simon

I am not a .NET guy, so there may be better approach for caching the reference data like Dictionary object as you said.

You may want to refer to http://www.eggheadcafe.com/articles/20030830.asp...

Hi Rob,

The data I have does not have a PK. It is basically a dump for a year from many locations and used for analysis on the avaliable fields.

While the...

Indeed a...

Jeff,

I can't get you the exact sample of what I have, but I'll try and get you something near to it soon.

BTW, the reference dataset used for lookup is filtered...

Hello Rob,

If I understand it right, you mean Pivot the CourseID columns and perform the lookup operation. If so, I would have to Unpivot it again as my destination table...

Comments have to be provided however not to the extent that one has to dig for the code. There are couple of points in the article that highlight on maitaining...

If you are writing code, you start commenting your own code. If developers in your team happen to visit your code frequently they will realize the difference.

At times I...

There are 'n' ways of defining a standard header. For this reason the only mention is about some basic information that CAN to be in there. And it completely depends...

I wanted to include  an example for the "Avoid copying and pasting comments" point, however, including the example in the same point would not have had much an impact. Great you...

Hi Clifton,

With Service Broker, there are areas that can have a negative performance impact and can be tuned with few additional considerations.

WAITFOR clause:

Without WAITFOR, the RECEIVE and GET CONVERSATION GROUP...

Hi Yelena,

I apologies for the delay in the response.

For your first comment, the GRANT statement is not case-sensitive, however the Service Broker's service names, contract names and message type names...

Hi Clifton,

There is some performance hit with 'Message retention' as explained above.

Regards,

Sachin