If possible, creative use of JOIN may provide the same information with less lag time. Using UNION The UNION statement is another way to return information from multiple tables using a single query.

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.