Haven't seen it, but perhaps the start of the job defaulted to success in the table? Usually if a job doesn't complete, from what I remember, there is nothing in...

Good suggestion. We bought this forum software, so I'll check and see if they've added it or I'm missing it.

Steve

These are articles are by the author of the whitepaper and will be coming every Wed for the next few weeks. They form the basis for a methodology that doesn't...

I love this

Questions posted to the site should be free of syntax errors...especially when one of the options as an answer is ... The query has a syntax error.

In...

Try something with this: http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

SELECT o.*, r.rownumber

FROM [order details] o

JOIN

(

    SELECT TOP 10 o.productid n, o.quantity, COUNT(*) AS rownumber

    FROM rs r

    GROUP BY o.productid

    ORDER BY COUNT(*) ASC

) b ON b.productid = o.productid

WHERE...

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.