which specific chips are effected?
No one knows for sure, and Nvidia isn't telling. The Inquirer says practically all of them, but their author has a history with Nvidia so there's quite a potential for bias there. The running theory is that the problem is due to thermal properties of a substrate material. This substrate material supposedly expands and contracts at a different rate than surrounding material in the chip package. Over time, this stresses the silicon or solder points, eventually causing a failure of the part. Laptop parts are definitely affected, you only need to look in notebook manufacturers forums and you'll see an incredible number of posts from owner of notebooks with, for example, 8600 GT mobile parts.
Desktop parts may also be affected, since they're all based on the same core silicon with (supposedly) the same substrate materials. It's possible that the problems aren't as apparent (at least not yet) due to the different thermal conditions you'd see in a tower chassis compared to a notebook. The very popular 8800GTs out there may start failing en masse in three months, six months, a year's time, or maybe never. Because Nvidia won't specifically say which parts are affected, whether it's all the parts or only certain manufacturing runs, etc., we have only speculation and rumor to go on.
All the simple programs have been written.