Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

RE: Expand / Collapse
Posted Friday, March 11, 2005 3:41 PM


Group: General Forum Members
Last Login: Wednesday, September 1, 2010 5:23 AM
Points: 108, Visits: 23

Its a surprise to read that!

So if, purely hypothetically, you had not that long ago gone through your entire applications 800 stored procs, ammended them all to be dbo.procname and changed every exec to include dbo. prefix and every call from asp to the same stored procs because you'd discovered it was good practice to guarantee cache hits...

You might have WASTED YOUR TIME because if there was a different case in any SP name or parameter name (*very likely*) when called from asp or another SP you would still not get as cache hit.

This is absolutely STUPID to enforce case for a cache hit and would only make sense if case was enforced when defining and calling the SPs themselves; t-sql and asp etc are all case insensitive - argh profanities!!

In my view this is definitely a flaw, a bug even.

Post #167360
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse