Results 1 to 3 of 3

Thread: Stored Procedures

  1. 09-20-2003, 06:15 AM #1
    Prasanna
    Prasanna is offline Registered User
    Join Date
    Sep 2003
    Location
    INDIA
    Posts
    21

    Stored Procedures

    How does the stored procedures actully help in solving the query faster?
    I know that Stored procedure execution plans can be reused, staying cached in SQL Server's memory, reducing server overhead.

    But how to check it using Query analyzer using execution plan? I want to practically see the difference.

    When we fire a single query on the database it gets cached then what's the difference?

    Thanks in advance,
    Prasanna.
    Reply With Quote Reply With Quote
  2. 09-22-2003, 07:53 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you are using the query only once, then there is not much gain. Stored procedures value becomes evident if the query is reused by many users.
    Reply With Quote Reply With Quote
  3. 11-02-2003, 12:52 AM #3
    Prasanna
    Prasanna is offline Registered User
    Join Date
    Sep 2003
    Location
    INDIA
    Posts
    21
    Another point is

    SQL Server 7.0 and 2000 can also catch the execution plans of Transact-SQL not in stored procedures.

    Thanks a lot.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules