Here’s the situation: You’ve worked extensively with SQL Server. Can you please explain how you optimized complex queries or stored procedures for large datasets, and what performance tuning techniques you applied?