title: Do certain SQL JOINS make your ASP.NET Application incredibly slow?
body: <p>I am talking about certain SQL JOIN (not all) which make your application crawling. I once produced this in my code and I thought it was really a bug by Microsoft. The problem was that the query performed just fine in SQL Management Studio but in your application it made everything stop for 10+ seconds unless the query completes. I think this is really a bug.</p>
  
  <p>An example of it is <a href="https://connect.microsoft.com/VisualStudio/Feedback" rel="nofollow">here in the Microsoft bugs/feedback site</a>. It take incredible 8 seconds just to go from one page to another. Can't they optimize this for god sake, if they could? This I believe is a manifestation of that bug.</p>
  
  <p>Have anyone come across it and can someone identify it? I am trying to troubleshoot my own slow queries but want to clarify this first.</p>