0
votes
1answer
57 views

Best practices for caching search queries

I am trying to improve performance of my ASP.net Web Api by adding a data cache but I am not sure how exactly to go about it as it seems to be more complex than most caching scenarios. An example is I ...
1
vote
1answer
349 views

Running SQL Server Express on Micro/Extra Small VM

I'm exploring options for running a small cloud Windows Server (either AWS EC2 Micro or Azure Extra Small). The server won't be hit very hard, but I need to run a simple relational database, which ...
1
vote
1answer
249 views

Table scaling with partitions or with separate databases?

Let's say I have a table (let's call it BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb. These daily INSERTs are ...
3
votes
1answer
140 views

Is there another name for Sql Azure's programming language?

According to this page on MSDN the sql language used on Sql Azure is called transact-sql (the same as on sql server). But is this the only way to refer to programming on Sql Azure? The Sql Azure ...