Interested to Buy Any Domain ? << Click Here >> for more details...
How to scale out a federation by Sql statement?
- 1 Answers
- 123 Views
- I also Faced
- E-Mail Answers
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 |
Define Wed Edition in SQL Azure?
What is SQL Azure Firewall?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What happens when the SQL Azure database reaches Max Size?
What is the current limitation of the size of SQL Azure DB?
What is the difference in accessing db between sql server vs sql azure?
Explain something about security and SQL Azure?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is code near application topology?
How many replicas are maintained for each SQL Azure database?
What are rest-style architecture's?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
SSRS SQL Server Reporting Services 
