title: SSRS report running very slow whereas the query runs super fast in SSMS
body: <p>I am running a very basic report in SSRS 2012. I am just retrieving some data from a table and I am using a parameter in the Where clause of the query. The query runs fast (in less than 5 secs) if I hardcode the parameter in the SSRS query but if it's left as a dynamically chosen parameter the query takes over 5 minutes to render. Here's an abstract query similar to what I am using:</p>
  
  <pre><code>Select Col1, Count(*)
  From Tbl1
  Where Col2 = @Para1
  Group By Col1
  OPTION (RECOMPILE);
  </code></pre>
  
  <p>I have already tried using OPTION (RECOMPILE) in the query to address the parameter sniffing issue. I have also checked the data types and Col2 is CHAR(2) and Para1 is TEXT so no conversion should be required at runtime.</p>
  
  <p>Any thoughts what could be causing this?</p>