Viewing 15 posts - 3,406 through 3,420 (of 3,614 total)
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
I would say "Comment the code". If you don't comment your code then you are asking to be nailed to your old projects for life or until you resign....
June 16, 2003 at 3:00 am
If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the...
June 13, 2003 at 1:59 am
On this site ages ago there was someone who was running two low grade servers in a profitable dot com and was getting very good performance out of them because...
June 13, 2003 at 1:52 am
Viewing 15 posts - 3,406 through 3,420 (of 3,614 total)