23,191 reputation
44593
bio website uk.linkedin.com/in/…
location London, United Kingdom
age
visits member for 3 years, 3 months
seen 15 mins ago

1h
comment Local SQL database settings to better mimic SQL Azure
You're somewhat in XY Problem territory. You need to understand what's causing the performance difference, rather than attempting to slow down your local environment to match Azure. Capture IO stats and execution plans for starters, add them to your question.
1h
reviewed Reviewed From where does the MySQL Query Optimizer read index statistics?
1h
reviewed Reviewed Best Indexing Strategy for Query with Equality[A], Range[B], Group By[C], AND Order By[count(P)]
1h
reviewed Reviewed Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
1h
reviewed Reviewed Generating Invoices and Tracking
16h
awarded  Reviewer
18h
reviewed Close Hi is there any to check that database table contains MULTIVALUE Columns
22h
reviewed Reviewed Getting error creating database in SQL Server 2005
23h
reviewed Reviewed Local SQL database settings to better mimic SQL Azure
23h
comment Local SQL database settings to better mimic SQL Azure
Can you provide some more information around the performance differences? Example io stats, cpu, execution times for local vs Azure. Local and Azure server specs along with queries and plans would also help.
1d
comment Is there a standard mechanism for moving data to a remote database?
Getting Started with Azure SQL Data Sync
1d
comment 500 databases or 1 database with 500 tables or just 1 table with all the records?
For your specific requirements (a new customer is just 2000 records in 1 table), in my opinion it would be option 3 for 500 customers. You'd probably want to start sharding at <some undefined number> of customers but not yet. A single table sounds suspicious though.
2d
reviewed Close SQL Server migration from 2005/2008 to 2012
2d
reviewed Close personal database
2d
reviewed Close I cannot add oracle listener with windows server 2008 r2
2d
reviewed Close One field with multiple values?
Oct
22
reviewed Close Are there any minimal sqlite extensions for running a server with role based access control?
Oct
22
reviewed Close SQL Server Performance
Oct
21
reviewed Leave Closed CLOB data type is not working as expected
Oct
21
reviewed Close How do I select all child table records based on condition