title: Small query on shared view takes a long time when someone else is running a big query on the same view
body: <p>Can anyone explain to me why a small query takes a long time on a shared view when someone is running a big query on the same view?</p>
  
  <p>I found a solution to the problem by using Table-valued function instead.</p>
  
  <p>But I'd like to understand why sharing the same view creates this problem in SQL SERVER 2014?</p>
  
  <p>The TVF and View queries the same tables, but why would the TVF consistently run faster?</p>
  
  <p>Here's the actual execution plan:</p>
  
  <p><a href="https://www.brentozar.com/pastetheplan/?id=SylaMlQqf" rel="nofollow noreferrer">https://www.brentozar.com/pastetheplan/?id=SylaMlQqf</a></p>