At what kind of scale? I don't think any web application should have problems unless the queries are very badly designed.

I've worked with MS SQL for 10+ years (at financial institutions) with no problems. Oracle might be a tad better, but it's also pricier. No idea about Postgre (I've heard it's good), but what you mention shouldn't be a good reason to dismiss MS SQL.