Viewing 15 posts - 1 through 15 (of 78 total)
Great going!!!
Congratulations and Best Wishes to Steve, SSC and RedGate...
January 29, 2009 at 2:09 am
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?...
January 5, 2009 at 8:16 am
Zanonil,
Can you elaborate more on CHECKSUM? An example would help.
January 5, 2009 at 7:57 am
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...
January 5, 2009 at 7:52 am
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...
December 30, 2008 at 6:17 am
kh (12/30/2008)
I find this related article very interesting:http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx
It describes the performace differences from Lookup, Merge, and Script Component used to solve the same logic. Very cool reference.
Indeed a...
December 30, 2008 at 5:55 am
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...
December 30, 2008 at 5:42 am
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...
December 30, 2008 at 12:40 am
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...
June 13, 2006 at 11:41 pm
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...
June 13, 2006 at 11:26 pm
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...
June 13, 2006 at 11:03 pm
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...
June 13, 2006 at 10:57 pm
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...
May 17, 2006 at 5:46 am
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...
May 13, 2006 at 2:52 am
Hi Clifton,
There is some performance hit with 'Message retention' as explained above.
Regards,
Sachin
May 10, 2006 at 1:57 am
Viewing 15 posts - 1 through 15 (of 78 total)