Option recompile and temp tables in a proc.

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  August 10, 2016 at 8:47 am

  #329175

  https://blogs.msdn.microsoft.com/robinlester/2016/08/10/improving-query-performance-with-option-recompile-constant-folding-and-avoiding-parameter-sniffing-issues/

  A good article regarding Option(recompile) in a proc with temp tables.

  You can get constant folding on the batches which later would have been triggered for recompile anyway, by identifying them and adding option recompile.

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  August 10, 2016 at 8:58 am

  #1894816

  Is there a question here? Or is this supposed to be informational?

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  August 10, 2016 at 8:59 am

  #1894817

  just a good article. No question.

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]