Viewing 15 posts - 34,711 through 34,725 (of 39,725 total)
I agree with your cost analysis at the low end, but when purchasing > 4 CPU boxes, or even considering it (4 v 8), the cost of entry is so...
July 27, 2004 at 11:04 am
1=1 is true, so it always returns something.
select 'test'
from orders
where 1=1 will return all the rows in the orders table.
July 27, 2004 at 10:05 am
If you can't do some ordering and looking for the previous value in the query (and I'm not sure you can), then this will work. For 100 rows, not sure...
July 27, 2004 at 10:04 am
It's too open ended a question to answer. If possible, a single or a few queries might be better, Without seeing some code or knowing what you are trying to...
July 27, 2004 at 9:33 am
If price isn't an issue, don't forget to load up on RAM and have a nice disk system as well. Separate logs from data from tempdb from system files and...
July 27, 2004 at 9:24 am
Rayven,
Thanks for catching that. I'll reword the answer. And thanks for the explanation. Both the author and I were stumped, but we knew someone would figure it out.
Steve
July 27, 2004 at 7:55 am
That's ok Troy. Most of the time I appreciate the ribbing. Today was annoying since I didn't really have the time and fixing things is a pain.
As far as the...
July 26, 2004 at 7:03 pm
The error log has that error? That usually is a corrupt file of some sort. Hve you run checkdb? Might need to contact MS PSS if it continues.
Also, can you...
July 26, 2004 at 7:00 pm
You can go to the newsletter archive (http://www.sqlservercentral.com/newsletter) or just reclick the link in the newsletter.
July 26, 2004 at 4:21 pm
I have corrected the scores for people that answered syntax error. It's hard to QA all these questions and in this case, I missed the single quote.
I know that many...
July 26, 2004 at 10:51 am
You could use a trigger to force it.
create trigger mytrig on Mytable for insert, update as
update mytable
set myfield = upper(myfield)
from inserted i
where i.pk = mytable.pk
July 26, 2004 at 10:44 am
Assuming you know the PK and the fields
select a.code 'Code_a', b.code 'code_b', a.amount 'amount_a', b.amount 'amount_b'
from MyTable a, MyTable b
where a.code = 'a' and b.code = 'b'
If you want it...
July 26, 2004 at 10:42 am
It appears that you had some type of corruption in the SQL tables at the physical level. If chkdsk worked, then bcp out/bcp in , transfer to new db, etc,...
July 26, 2004 at 10:37 am
Part of the problem is the execution plans are based on the load on the server. Since I've managed people with both Oracle, DB2, and SQL Server, the SQL installations...
July 26, 2004 at 10:30 am
Did you assign the min and max to 5120?
Check sp_configure.
July 26, 2004 at 10:28 am
Viewing 15 posts - 34,711 through 34,725 (of 39,725 total)