I have this habit of never using Sub-Queries in any of my SQL Statements. I'm not sure why I started this, but it is one of those things I avoid at all costs.
Is this fear justified? Or do you think I'm making a big deal out of something that I don't need to?
Do you use subqueries? If so when and why?
Also keep in mind that I'm usually working with procedures that need to respond in subsecond times. This means anything that takes longer than 500ms is usually going to get re-written until it only takes 10-20ms.