SQL Server 2000 Best Practices

Very useful article on SQL Server 2000 Best Practices

http://www.extremeexperts.com/SQL/Articles/BestPractices.aspx

Normalize your tables
Avoid using cursors
Index Columns
Use transactions
Analyze deadlocks
GOTO Usage
Increase timeouts
Avoid NULLable columns
TEXT datatype
SELECT * Usage
Temporary tables usage
Using UDF
Multiple User Scenario
Use SCOPE_IDENTITY