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...

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.

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...

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...

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...

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

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...

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...

You can go to the newsletter archive (http://www.sqlservercentral.com/newsletter) or just reclick the link in the newsletter.

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...

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

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...

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,...

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...

Did you assign the min and max to 5120?

Check sp_configure.