How to scale out a federation by Sql statement?
Answer / Prashant Kumar Srivastava
Scaling out a federation in SQL Azure cannot be done with a single SQL statement. Instead, you should use the Federation Creation Wizard or T-SQL scripts provided by Microsoft. The process involves creating a new database for each shard and then adding that database to the federation.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is SQL Azure Fabric?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Explain tables in SQL Azure?
Which tools are available to manage SQL Azure databases and servers?
Explain the Ways to improve the performance of a sql azure database?
What is the current pricing model of SQL Azure?
What is function of master database?
How many servers can we create in a single subscription?
How do we Backup SQL Azure Data?
How to connect to SQL Azure Database by using sqlcmd?
What is SQL Azure Federations?
Which are the two editions in which SQL Azure database available?