I fluctuate between having no comments at all or using a full comment such as...
/***********************************************************************************
**
** Server: SQLL032P
** Database: iPR
**
** Script Name: 0001_Split_Relevant_References_By_XML_Name_Value.sql
** Description: Script splits out the node names and values of the data filtered
** by the variables listed in line 54 onwards.
**
** Author: Ian Roke
** Created: 15/11/2008
** Modified: 21/11/2008
**
** Notes: Creates two temporary tables.
** - ##SelectData
** - ##SplitXML
** Uses a cursor to loop through data and split XML.
**
** Inputs: Filters to show relevant detail. (Line 54)
**
** Outputs: XML BLOB split down into name/value stored in ##SplitXML table.
** Data only available in scope of script.
**
***********************************************************************************/
What do you guys do?