The RECOMPILE Options

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Suresh Maganti » The RECOMPILE Options

34 posts, Page 4 of 4

«««1 2 3 4

The RECOMPILE Options

Rate Topic

Display Mode

Topic Options

Author

Message

GilaMonster

Posted Sunday, July 10, 2011 6:43 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651, Visits: 29,903

Grubb (7/7/2011)

Thanks for the links, Steve!

As an aside, Gail is teaching an entire class on Execution Plans at this year's PASS conference: http://www.sqlpass.org/summit/2011/Speakers/CallForSpeakers/SessionDetail.aspx?sid=1245

Minor correction. Grant and I are teaching that together. Should be awesome fun.

See you there.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1139437

Ray Giacalone

Posted Tuesday, July 12, 2011 1:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 11:39 AM
Points: 8, Visits: 15

Oddly enough, I have a stored proc that is called by Excel through ADO however Excel will crash everytime giving a generic error UNLESS I have the WITH RECOMPILE clause in my stored procedure.

Post #1140626

@SixStringSQL

Posted Tuesday, July 12, 2011 3:21 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:22 PM
Points: 65, Visits: 254

GilaMonster (7/10/2011)

Minor correction. Grant and I are teaching that together. Should be awesome fun.

See you there.

It's gonna be awesome!

Gail, what is your Avatar a picture of?

-Grubb

Post #1140695

GilaMonster

Posted Wednesday, July 13, 2011 1:12 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651, Visits: 29,903

Grubb (7/12/2011)Gail, what is your Avatar a picture of?

Marcus Cole. Character on Babylon 5. Same place my sig quote is from.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1140772

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions