I'm not sure that you're interested but, for me, check lists are uber important when writing code. I'll take a requirements document, draw a process chart of what needs to be done, and the first bit of code that I write are actually in the form of comments in the code as to what needs to be done and why. Not only is it a check list, but it's automatic documentation in the code.
My general rule of thumb is that if you remove all code from something (stored procedure, view, function, whatever), the comments that remain should allow you to rebuild the process flowchart with little other knowledge of the system.
Of course, comments like "Update the Customer table" are stupid and absolutely worthless because it's missing the "WHY". "Give each qualified customer the current bargain discount on their next purchase" (for example) would be a much better comment because it very simply states why that particular section of code exists and in generic enough terms so the comment doesn't need to be maintained for minor code changes.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)