title: Query Optimization Tips
body: <p>I been looking for some general Tips and Tricks for Query Opitimization in SQL Server 2008.</p>
  
  <p>I came accross the below which am quite unsure what are the consequences of using views / triggies</p>
  
  <ul>
  <li>Try to replace views with original source table  </li>
  <li>Triggers should not be used if possible, incorporate the logic of trigger in stored
  procedure</li>
  </ul>
  
  <p>Can someone shed light on these explaining pros and cons and also point me to list of general Tips and Tricks for Query optimization.</p>