Key factors for efficiency of SQL server 2000 (performace tuning)

Hello All,

I am new to SQL Server 2000. I am eager to learn what factors/parameters are key for obtaining good retrieval performance of SQL Server 2000 (prompt response to user query).

I recall that someone told me that a recordset with asOpenStatic cursor type has higher speed than that of a recordset with other cursor types.

Is this true or false. Are there really some key parameters for perfomance tuning .

Thanksyes, that is true.
check
http://www.sql-server-performance.com/sql_server_performance_audit.asp|||A big key to performance tuning is to avoid cursors, static or not.