Tuning SQL techniques

Question

Hello, 

 

Can you please advise some good resources for below items which heelped for you. 

 

1 - Tuning Slow SP's

2 - Rewriting Slow SQL requires. 

3 - Good Indexing techniques. 

4 -Optimizing SSIS packages

 

I would really appreciate any inputs. 

 

Thanks. 

Siz