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)....
Please kindly advise this, my storeprocedure structure is as below.
The purpose is, While Insert in TableA if there is any error occour Then I want to ROLLBACK TRAN of TableB that related with the current Transaction of TableA, if not COMMIT TRAN.
When execute it I have got the error
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1159.
DECLARE Cur_1 Cursor LOCAL FORSelect col1,col2,col3 from table1
FETCH NEXT FROM Cur_1
INTO@col1,@col2,@col3WHILE@@FETCH_STATUS = 0BEGINDELETEFROMFROM TableA Where match with@col1,@col2,@col3DELETEFROMFROM TableB Where match with@col1,@col2,@col3DECLARE Cur_2 LOCAL FORSelect * from table2 Where match with@col1,@col2,@col3OPEN Cur_2
FETCH NEXT FROM Cur_2
WHILE@@FETCH_STATUS = 0BEGINBEGINTRANINSERTINTO TableB (data from Cur_2 & Cur_1)
FETCH NEXT FROM Cur_2
INSERTINTO TableA (data fromCur_1)
IF@@ERROR = 0COMMITTRANELSEROLLBACKTRANFETCH NEXT FROM Cur_1
To add to Geoff's answer, it is always a best programming practise to enclose transactions inside a Try Catch block, like this:
BEGINTRANSACTION-- DO YOUR STUFF HERECOMMITTRANSACTIONEND TRY
IF (@@TRANCOUNT > 0) ROLLBACKTRANSACTIONDECLARE@ErrMsgVARCHAR(8000), @ErrSeverityINTSELECT@ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY()
I would like to know if this is true for MS SQL Server. Lets say you have 1000 users in your MS SQL database. Does a person has to pay for each of those 1000 of users who uses your application which connects to the database to retrieve the users information.
Last Visit: 31-Dec-99 18:00 Last Update: 15-Jun-21 22:53