Comments by dmjm-h - CodeProject

dmjm-h 13-Jul-16 16:31pm View

Reason for my vote of 4 \n If you use OBJECT_DEFINITION() instead of syscomments you won't need to GROUP BY. syscomments supplies the text in chunks of 4000. OBJECT_DEFINITION() gives you all of the text.

dmjm-h 5-Jul-16 14:09pm View

Reason for my vote of 3 \n You did not give enough explanation of how the mechanisms work. Also, if you use delegates you should be prepared to explain their usage, not just ignore them.

dmjm-h 26-Apr-16 0:00am View

Reason for my vote of 5 \n Well-written. I dislike javascript for exactly that reason - it's a function, it's an object, it's a string, until it isn't.

dmjm-h 26-Feb-16 16:52pm View

Reason for my vote of 4 \n Good article, but aspiring to be the Dave Barry of software development gets old.

dmjm-h 1-Jan-16 18:06pm View

Reason for my vote of 5 \n Well-written and an intriguing idea. Not that I would ever do it.

dmjm-h 22-Dec-15 10:13am View

Reason for my vote of 3 \n This tip should be re-categorized as a classified ad - job wanted. There's something off when the bio is a full resume that's longer than the tip.

dmjm-h 22-Oct-15 16:46pm View

Reason for my vote of 5 \n Well written. I particularly appreciate all the helpful links.

dmjm-h 4-Sep-15 17:39pm View

Reason for my vote of 5 \n Simple, elegant, useful. I wish more CodeProject code was like this.

dmjm-h 9-Feb-15 23:17pm View

Reason for my vote of 2 \n Very little explanation.

dmjm-h 6-Feb-15 18:01pm View

Reason for my vote of 5 \n Continuing high quality of content and presentation. Again, thanks.

dmjm-h 7-Jan-15 17:43pm View

Reason for my vote of 5 \n Well-written article with plenty of susbstance. Ignore the C supremacists. They froth up very quickly when they think their domain is threatened.

dmjm-h 17-Nov-14 18:37pm View

Reason for my vote of 4 \n I thought was it quite interesting but I knew people would pick holes in it. I use the KeyPress technique in some internal programs that only I and a power user use. It's handy for cutting out the occasional mis-type without putting the user through the whole "show an annoying message and maker her type it again" routine.

dmjm-h 28-Oct-14 17:20pm View

Reason for my vote of 5 \n Useful tip.

dmjm-h 5-Sep-14 11:24am View

Reason for my vote of 3 \n I would have appreciated a summary at the beginning so I did not have to plough through all the code to discover the method.

dmjm-h 10-Jan-12 12:14pm View

Deleted

Did you get any comparative timings (bulk copy vs LINQ to SQL)?

dmjm-h 6-Dec-11 13:35pm View

Deleted

Is there any significance to doing the rollback before the raiserror?

dmjm-h 1-Nov-11 11:40am View

Deleted

Reason for my vote of 2
Possible but (to some of us) not preferable.

dmjm-h 26-Oct-11 12:30pm View

Deleted

Reason for my vote of 1
advocating recursion and barely readable lambda mumbo-jumbo in the same post. For FACTORIAL??

dmjm-h 25-Oct-11 20:31pm View

Deleted

Reason for my vote of 5
Thanks for taking the time to point it out. If you Google the problem it seems like most of the solutions use the wrong view, i.e. one with the first 4000 chars.

dmjm-h 25-Oct-11 20:13pm View

Deleted

Reason for my vote of 5
Excellent presentation of the subject.

dmjm-h 25-Oct-11 19:44pm View

Deleted

Reason for my vote of 5
You had me at "fancy lambda stuff"

dmjm-h 29-Aug-11 11:22am View

Deleted

Reason for my vote of 3
John's later post indicates that SELECT * is the least of his problems. It sounds like everything about the project is a cluster thing. Chris's comment articulates it well.
Lashing out against SELECT * in frustration is understandable but unwarranted. We don't ban every SQL statement variation that might be misused.

dmjm-h 19-Jul-11 9:08am View

Deleted

Reason for my vote of 5
I love it.

dmjm-h 25-May-11 12:26pm View

Deleted

I gave it a 4 because it's a well-performed trick. I would never use it as my preference is for verbose code even if it looks pedantic. I never did use 'with' in vb because I want to see what the variable is, wherever it may be. I'll gladly substitute an extra variable for a long chain to improve readability, knowing that there can be scope issues.

dmjm-h 17-May-11 11:15am View

Deleted

Reason for my vote of 5
Correct. sql_modules has the complete text, unlike syscomments.

dmjm-h 3-May-11 11:59am View

Deleted

Reason for my vote of 2
syscomments gives you the first 4000 chars. Use object_definition(object_id('objectname')) to search the entire text.

dmjm-h 12-Apr-11 12:10pm View

Deleted

Reason for my vote of 5
What a great message! Thanks for sharing. Now I don't feel so bad about occasionally taking a wrong turn in code.

dmjm-h 12-Apr-11 12:05pm View

Deleted

Reason for my vote of 2
I don't get it. You wouldn't combine methods with different purposes just to reduce the count of methods so why would you do it with sp's?

dmjm-h 22-Feb-11 10:21am View

Deleted

Reason for my vote of 5
Valuable info

dmjm-h 31-Jan-11 13:31pm View

Deleted

Reason for my vote of 5
IMHO the superior technique. I don't want to use a construct for other than its intended purpose, be it a loop or an exception.

dmjm-h 31-Jan-11 13:23pm View

Deleted

sorry - wrong vote button - comment belongs on original post

dmjm-h 31-Jan-11 13:20pm View

Deleted

Reason for my vote of 2
The line number option is exactly where one would expect to find it. A tip should have something unusual about it - maybe an option that's difficult to find or a new use for a known feature.

dmjm-h 24-Jan-11 16:48pm View

Deleted

Reason for my vote of 4
As you say, would all but eliminate the hard-to-detect error of mis-ordering arguments in a long list.

dmjm-h 24-Jan-11 16:34pm View

Deleted

Reason for my vote of 4
Quite elegant

dmjm-h 27-Dec-10 11:11am View

Deleted

Reason for my vote of 4
Well explained.

dmjm-h 13-Dec-10 11:34am View

Deleted

Reason for my vote of 4
Good explanation, examples.

dmjm-h 16-Nov-10 11:10am View

Deleted

Reason for my vote of 3
Delegates have their uses but I suspect this is not one of them. Granted you are aware of the mismatch of existing design and new requirement but I foresee difficulties with the next new functionality.

dmjm-h 16-Nov-10 11:01am View

Deleted

Reason for my vote of 4
Useful tip. Sometimes you need to re-populate a table from another and want to avoid DROP/CREATE.

dmjm-h 9-Nov-10 13:44pm View

Deleted

Reason for my vote of 3
Useful reminder for beginners.

dmjm-h 25-Oct-10 18:38pm View

Deleted

Reason for my vote of 3
If you expect to execute the line of code many times then garbage collection may be an issue. Even so, the compiler may be generating StringBuilder-like code. Does anyone know what the compiler does?

Comments by dmjm-h (Top 40 by date)