How would you write optimized SQL queries for large datasets in MS SQL Server at Advanced Micro Devices?