I prefer to add my comments after the create procedure, eg

create proc rpcNameOfProc

   @AcctMonthEndDate datetime

as

--Custom script created for Client

--This script should be reinstalled and tested at time of an upgrade.

--Name...

There are different ways of thinking about it but one way is ...

Oracle                     SQL

Database       =     Server

Schema         =     Database

This would suggest a number of databases, rather than one database with a number...

It depends on what order you apply the tests in the where clause and the outer join.

So if you join table a with a left join to table b -...

Do you have outer joins in the view?  In some circumstances Oracle and SQL give different answers to queries involving outer joins.

There are certain rules about how you can delete log files that I have never understood. The practical upshot seems to be you can never shrink them as much...