What is the index requirement in SQL Azure?
Answer / Priyanshu Jain
SQL Azure requires that all user-created tables have a clustered index. This index determines the physical order of data on disk and is used to speed up data retrieval. By default, the primary key column(s) are used for the clustered index.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the differences between web role and worker role?
What is federation member?
Explain iaas, paas and saas?
What is SQL Azure Data sync?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is the current pricing model of SQL Azure?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is SQL Azure Fabric?
What were the latest updates to SQL Azure service?
Define Wed Edition in SQL Azure?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
When does a workload on SQL Azure get throttled?