Interesting topic and I have seen some really bad ideas.

Never, NEVER prefix databse objects with their type (i.e. tblEmployees, colLastName, spCalculateInvoice). Anyone monkeying around in the...