SQL Server - Reduce number of Reads
I have one general question about optimization at SQL Server: How I can reduce number of Reads in stored procedure? 

I'm interested in good practices like: 
- creating indexes at physical and temp tables
- using temp tables instead using same table couple times in procedure
- DDL before DML
- SET NOCOUNT ON at the beginning of stored procedure
- ...

We have issue with disk space that is used because of huge number of reads that is caused by couple stored procedures and I need to optimize it.

TnX in advance!

Nemanja
SQL Server - Reduce number of Reads
===

I have one general question about optimization at SQL Server: How I can reduce number of Reads in stored procedure? 

I'm interested in good practices like: 
- creating indexes at physical and temp tables
- using temp tables instead using same table couple times in procedure
- DDL before DML
- SET NOCOUNT ON at the beginning of stored procedure
- ...

We have issue with disk space that is used because of huge number of reads that is caused by couple stored procedures and I need to optimize it.

TnX in advance!

Nemanja