Re: System Cache and expiration

"Marina" <someone@xxxxxxxxxx> wrote in message
news:uAEWlFpoFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
> Maybe as input your stored procedure can accept a list of columns the user
> wants, and only return those.

Is that Dynamic Sql?

Tom
>
> "tshad" <tscheiderich@xxxxxxxxxxxxxxx> wrote in message
> news:uM2rbaooFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
>>I was discussing a question in the Sql Server group on how to handle
>>Stored Procedure and how many to have as well as whether or not to read a
>>whole record into my page if I only need a few fields out of it.
>>
>> The reason being that I could have 15 pages all wanting different types
>> of data and this would require 15 different SPs. Or I could just have
>> one stored procedure that reads the whole record and always read that one
>> and grab what you need. The problem here might be networking issues on
>> sending large amounts of data when just a few fields will do.
>>
>> The question was do I create another SP each time I create a new page
>> that needs an extra field from the other SPs, or just read the whole
>> thing.
>>
>> One of the solutions was to read the whole thing into a class and cache
>> the class (session), but the problem was how do I handle changes
>> (updates, deletes) that may hit that record from another users.
>>
>> His other solutions was:
>>
>>> If there are concurrency issues, then don't use Session: use the system
>>> cache (or Application). With the system cache, you can set an expiration
>>> time on the objects stored there, as well as including code to flush the
>>> class from the cache when an update occurs.
>>
>> I was wondering how I would do this, to have an update trigger the
>> deletion or reload of an object in the system Cache.
>>
>> Also, is the system Cache the same as the Application?
>>
>> Thanks,
>>
>> Tom
>>
>
>


.

Relevant Pages

  • Re: System Cache and expiration
    ... Maybe as input your stored procedure can accept a list of columns the user ... > needs an extra field from the other SPs, or just read the whole thing. ... > the class (session), but the problem was how do I handle changes (updates, ... > deletion or reload of an object in the system Cache. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... stored procedure, the user needs EXECUTE rights to the stored procedure. ... Query 1 requires the user to have SELECT rights on the Customers ... Also, FWIW, the dynamic SQL is only syntax checked at run time, not when the ...
    (microsoft.public.sqlserver.tools)
  • Re: stored procedure security
    ... > execute privelages on the stored procedure, ... As soon as you employ dynamic sql, the logon executing the stored procedure ... In order to execute this stored ...
    (microsoft.public.sqlserver.security)
  • Re: DENY table SELECT, GRANT stored proc EXEC, but EXECUTE a string
    ... Once you go to dynamic SQL, you are outside the ownership / security context ... I wrote a script that GRANTS EXECUTE to ... every stored procedure in the database to and DENY ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Injection Prevention
    ... here is the summary from my posts to that thread that are related to your ... introducing another SQL injection vulnerability. ... of triggers that are using dynamic sql). ... dynamic SQL in stored procedure is much more likely to occur than ...
    (microsoft.public.dotnet.security)