Dan Chick
NEVER make a table's primary key contain actual information, it must always be a number or guid.
Comment your code FIRST. Lay out your page with skeleton comments and fill in the code.
Use good variable names.
- Personally, I will not use Hungarian notation in typeless languages where variables can be strings OR numbers.
Let the database do what it can do.
- Once I had to update a certain subset of rows. I ran a query to get my rows, looped over them, and ran update queries. When the rowcount got large it was very inefficient. Rewriting the whole page with a single advanced sql query knocked the execution time way down.