SQL Azure Performance – Query Optimization

SQL Azure Performance Tuning is a much tougher task than SQL Server, as I noted in the Azure Report Card – SQL Azure lacks some of the basic tools available to SQL Server DBA’s.

There really isn’t too much to do tuning your SQL Azure instance as almost all the settings available for SQL Server are automatically managed by the SQL Azure platformHowever, there is still some performance tuning to be done – mostly in the execution of the operations performed by the database.

A major tool missing from SQL A...