Yup. I've seen some nasty stuff from vender software. From 38 indexes in one table, with the same leading column, to 'temporary' tables that don't get dropped (we had 150000 tables after a year and we didn't know if we could drop them) to reimplementing the nested loop join in CLR.

Jeff, I envy the position you have. Here we get absolutely no say in what products are bought (except for DBA-type tools) and have to 'make it work' regardless of what.

Usually the database team are the last people consulted about anything, from product purchases, to server specs, to table and database design

*sigh* Sorry, I'm ranting again