Stored Procedures and Caching

Question

Post reply

Stored Procedures and Caching

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Big applause. Great article. Nice and tight delievery.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Hm, I would call it a bit of article recycling.

Without compromising the quality, Brian.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

K. Brian Kelley SSC Guru Points: 114562 More actions · Answer 3

I would agree, Frank, but I had nothing to do with it, honest!!! Every so often they re-schedule some of the older articles and I guess it was my time. I'm not complaining!

K. Brian Kelley
@kbriankelley

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Hey, Brian, why should you complain anyway? I like the article, too.

And I'd rather read a good article twice or more than a not so good article once.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 5

Brian,

Really nice job on the "Stored Procedures and Caching" article. Looks like a few other folks share my sentiment. Definitely above the norm of what I've come to expect from "authors", professional or not. Thanks for the great read.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Alon Biran SSC Journeyman Points: 93 More actions · Answer 6

Great article. As a former mainframe DB2 DBA, I was used to having more control over buffering and caching than what SqlServer allows - for better and for worse. and it's good to know a little bit more of the internal behaviour, even if just at a glance, to avoid some future pitfalls. Your article enlightened me.

Anyway, I think there may be a way around the recompilation problem of procedures with interleaved DML and DDL using nested stored procedures, but I may be wrong... I should try it some time.

Praveen Kumar Pasula SSC-Addicted Points: 421 More actions · Answer 7

Brian, i was unable to reproduce the CacheMiss when i executed a SP without specifying owner name. I followed the steps which u mentioned like creating a non-dbo account, creating a dbo owned SP etc., for testing this scenario. But i always got the ExecContextHit event instead of CacheMiss from the second execution.

Could you please give me some more details on how to reproduce this.

Thanks for such a great article.