SQL Feeds - All your SQL feeds in one place.

Thursday, April 15, 2010

Using the OPTION (RECOMPILE) option for a statement

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/15/2010 1:28:00 PM

I started this series with the post titled: Little Bobby Tables, SQL Injection and EXECUTE AS. I then moved to discussing some of the differences with the post titled: EXEC and sp_executesql - how are they different? Today, I want to address a few of the comments as well as continue with a few tips and tricks using these commands. First off - could we have helped the performance of the sp_executesql statement? Yes... If we know that a statement returns a varying amount of data (base ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us