3 articles, 3 books. Go to books ↓

Indexes play an important role in improving performance of queries, by allowing SQL Server to scan a limited number of rows. When queries involve tables from the same database, SQL Server can choose the best indexes available. Can SQL Server take advantage of indexes when querying multiple databases? In this tip, I'll explore the performance of cross-database queries in Azure.

Elastic database transactions for SQL DB enable applications to make atomic changes to data stored in several different SQL Databases.