Thanks Dave, I agree with your experience and sentiments, the 1000 column view limit is definitely the most common one that occurs.
Usually compounded or occurring with investments because it isn't realised that 'investment' itself isn't a real object, it's abstract, and so its count of attributes are added to all 'concrete' investment objects like projects, assets, etc.
I will likely have some additional follow-up comments to make soon too.
Wanted to get this one out there though, it was news to me and occasionally we are also hit by "our temp space is blowing up and our DBAs are unhappy" problems also, and this may well be one of the reasons.