SQL best practices for better performance

In general while developing the queries the required result will retrieve from query.  But the performance will be down after some days in production server due to data .In the scenario we have optimize the queries. So  while developing the sql queries, stored procedures we follow some techniques for better performance. Below links for some of the practices sql queries.