title: How to speedup joins
body: <p>I'm using SQL server 2008r2. I have a problem of returning data to the user because of massive joins (for example I need to make 5 inner + 6 left joins in one query (usually tvfs, sometimes tables). It takes toooo long.)</p>
  
  <p>What are the workarounds for this problem? 
  Should I denormolize my database? 
  What are the best practices to avoid huge number of joins?</p>