Don't quite understand the question. Those examples you gave are applications consisting of several different layers etc.
If you mean that could Sql Server serve as the back-end for the data, why not? Sql Server is capable of data distribution between several server, workload balancing, distributed transactions etc. so I see no direct reason why it couldn't handle the data.
It can handle the data and workload, its just that these online companies and startups (as they were) opted for the cheapest option (ie free) back when they started up, to minimise startup costs. They carry on using these systems as it will be too costly to migrate onto another platform.
Yes, from the economics point of view the situation is different. For example Oracle has quite good concept now when MySql can be used when starting up and when performance etc problems arise, you can migrate to Oracle with a bit less work than to other database flavors.
Services like Facebook etc. need to be massively parallel and fault tolerant, to get the same level of service from sql server would mean a heavy investment in licenses, also these sites are using unix servers and sql server is not supported on them.
Its the man, not the machine - Chuck Yeager
If at first you don't succeed... get a better publicist
The simple answer is, yes, SQL Server can handle the volume of data these sites catered for. The key thing to note about these sites, though, is that they tend to opt for NoSQL[^] databases - which is not what SQL Server is designed to do.
And I'm betting they have a serious investment in SQL Server licences. And they will almost certainly have had direct support from MS if they are pushing the edge of the tech. I know we were offered all sorts of incentives to use MS high volume framework including direct intervention from MS techs. Mind you the licences were $1m+.
Never underestimate the power of human stupidity
I am using a password protected DB. When i try to read from that table from another DB it is asking for the password. how to give the password. my query looks like this
" insert into table select from table in 'database'" .
in which the database is password protected. Any idea?.....
Please let me know how can i check whether the i/p parameters were
Null or empty and raise error and let user know that particular parameter is null or empty when he is trying to execute the SP (Stored procedure)....