|
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.
|
|
|
|
|
As said before, it's a financial decision. The Amaren[^] Nuclear Plant, and MacLaren[^] are using Sql Server. To be fair; they're doing something more complex than putting some html-pages in there
Bastard Programmer from Hell
|
|
|
|
|
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
RAH
|
|
|
|
|
Pretty sure most companies are more than willing to offer incentives and support for large contracts.
And if one goes with a non-paid solution then of course one had also be prepared to provide ones own support for all possible problems.
|
|
|
|
|
if sql server can handle NASDAQ[^] then it could handle anything any of us could throw at it.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
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?.....
|
|
|
|
|
|
Hi,
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)....
|
|
|
|
|
You mean inside the stored procedure? You can use IS NULL operator:
create procedure foo @param1 decimal as
begin
if @param1 is null
begin
raiserror('param1 is null', 16, 1);
end;
end;
exec foo 1;
exec foo null;
|
|
|
|
|
create procedure Myproc @myvar1 decimal as
begin
if @myvar1 is null
begin
error('@myvar1 is null', 16, 1);
end;
end;
|
|
|
|
|
Yes, what Mika said, but you're still better off wrapping a Data Access Layer around your database to check things like that.
|
|
|
|
|
You can check your parameter is null or empty. there are various way in sql server or oracle database.
declare @IP NVARCHAR(SIZE)
IF(@IP IS NULL OR @IP = '')
BEGIN
SQL STATEMENTS.
END
ELSE
BEGIN
SQL STATEMENTS.
END
IF(@@ERROR > 0)
SQL STATEMENTS.
|
|
|
|
|
Hi..
check your parameter is null or not.
in stored procedure
if(parameter is null or parameter ='')
begin
sql statements
end
else
begin
sql statements
end
or
in single query.
select * from tbl where parameter is null or parameter =''
|
|
|
|
|
Trying to install the following patch to fix a SqlBulkCopy/ADO.NET timeout issue when loading data
http://support.microsoft.com/kb/913177/[^]
However, when I run the installer "ndp20-kb916002-x86" (SQL 2008 on 32 bit Windows 2008 server), I got the following message:
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program"
Has anyone run into this problem before?
Thanks
dev
|
|
|
|
|
Haven't seen that problem but could be related to the fact that the fix is older than your server environment. As a workaround, have you tried enabling MARS?
|
|
|
|
|
Dear all,
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 FOR
Select col1,col2,col3 from table1
OPEN Cur_1
FETCH NEXT FROM Cur_1
INTO @col1,@col2,@col3
WHILE @@FETCH_STATUS = 0
BEGIN
DELETE FROM FROM TableA Where match with @col1,@col2,@col3
DELETE FROM FROM TableB Where match with @col1,@col2,@col3
DECLARE Cur_2 LOCAL FOR
Select * from table2 Where match with @col1,@col2,@col3
OPEN Cur_2
FETCH NEXT FROM Cur_2
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRAN
INSERT INTO TableB (data from Cur_2 & Cur_1)
FETCH NEXT FROM Cur_2
END
CLOSE Cur_2
DEALLOCATE Cur_2
INSERT INTO TableA (data fromCur_1)
IF @@ERROR = 0
COMMIT TRAN
ELSE
ROLLBACK TRAN
FETCH NEXT FROM Cur_1
INTO @col1,@col2,@col3
END
CLOSE Cur_1
DEALLOCATE Cur_1
modified on Friday, September 2, 2011 12:35 AM
|
|
|
|
|
Your problem is that your BEGIN TRAN statement is inside a WHILE loop and hence it will be executed every time the loop code is executed. You need to move it outside the loop.
|
|
|
|
|
To add to Geoff's answer, it is always a best programming practise to enclose transactions inside a Try Catch block, like this:
BEGIN TRY
BEGIN TRANSACTION
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
DECLARE @ErrMsg VARCHAR(8000), @ErrSeverity INT
SELECT @ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY()
RAISERROR(@ErrMsg,@ErrSeverity,1)
END CATCH
|
|
|
|
|
try something like this.
start your transaction
begin transaction a
insert into tableA
if(@@rowcount > 0)
begin
insert into tableB
commit transaction a
end
else (@@error > 0)
begin
rollback transaction a
end
|
|
|
|
|
Hi Guys,
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.
Thanks
|
|
|
|
|
With different licensing this would be a case for CPU license.
|
|
|
|
|
Possibly - the art of deciphering the licencing framework for SQL Server is not one you can easily acquire.
We got to the point where we outlined our business model to the MS rep and asked for the best licencing model. I hope he gave us the right one. I'm sure there is a business opportunity there for someone to offer licence model consulting.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Possibly - the art of deciphering the licencing framework for SQL Server is not one you can easily acquire.
So true. It took me quite some time to figure out what all the information meant. The MS rep in this case can help.
My response is based on the dollars per seat would defiantly be more than the CPU license. I do not remember exactly but the cutoff was around 150 seats (I think).
|
|
|
|
|
There is a break even point where the Cost Per Seat becomes more expensive than the Per CPU. I think the breakeven point is actually quite low at something like 100 Per-User licenses? though I could be wrong.. After this point its more cost effective to just license the box.
JC
|
|
|
|