What are some good tutorials for SQL performance tuning?

EDIT: Adding some more detail here. I'm specifically looking for help performance tuning SQL Server stored procedures.

I don't know why this was tagged with MySQL, I removed that. I'm working with TSQL sprocs on SQL Server 2014.