May 5, 1998

Improve Stored Procedure Speed

When developing stored procedures in SQL Server, use the SET NOCOUNT ON option at the start of your procedure. This will prevent the superfluous “row count” messages from being generated,

Declare Your Objects Properly

Never declare a variable as a “New” of type “object,” but always rather just as of type “object.” If you do so you will always increment the reference count of