Viewing 15 posts - 3,406 through 3,420 (of 3,617 total)
quote:
Always, always, always cluster/primary key the ident in a reference table.
OK, I have a table...
June 26, 2003 at 2:41 am
Robert,
I would generally consider selecting from a non-existant table to be a bug rather than an error.
In cases where it can be a legitemate programming error I would tend to...
June 26, 2003 at 2:25 am
If your store procedure fails before hitting a RETURN statement then the return value will be zero. This is the same value that you have used if your stored...
June 26, 2003 at 2:16 am
quote:
reminds me of some evil joke with mathematicians and algebraic sign errors.
Not "Solution...
June 25, 2003 at 5:02 am
quote:
Just thinking off the wall for a moment, would a stored procedure with a case statment containing the values be quicker?
June 25, 2003 at 3:21 am
I always put a primary key on tables even if I have to use an identity column to force one. Thinking back to my MS Access days the SQL...
June 25, 2003 at 3:19 am
quote:
.. If its an internet app then not very much x huge audience = major headache.Not sure if I get the meaning
Cheers,
Frank
June 25, 2003 at 3:01 am
I would tend to index the table on principle but if it is virtually static I would make sure that the index has a very high fill factor.
As you will...
June 25, 2003 at 2:29 am
quote:
SQL Server can run perfectly fine if it's not an administrator on the system.
I think...
June 23, 2003 at 2:09 am
I think you need to be careful here. Although 15hours to back-up a 30Gb database does sound too long it sounds like the back-up of your SQL Server is...
June 23, 2003 at 1:53 am
I used to work on an HP3000 mini computer where the console was the ultimate controller of the mini, then there were administrators and finally users.
There used to be a...
June 20, 2003 at 5:21 am
Thanks for your comments.
My concern with "properly" locking down a server, be it SQL, IIS or whatever is where do you learn to do it "properly"?
I've read a...
June 20, 2003 at 4:44 am
I don't think the question has a single correct answer. I think this one is a case of "an" answer rather than "the" answer.
Having had to do this for...
June 19, 2003 at 2:13 am
From a financial perspective Active/Passive is cheaper as the licensing is for the Active instance.
June 16, 2003 at 3:15 am
Viewing 15 posts - 3,406 through 3,420 (of 3,617 total)