How do you approach query optimization and performance tuning in SQL Server 2008 or newer environments?