Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
panditkudale
Starting Member
1 Post |
Posted - 2006-02-07 : 04:58:25
|
hi to alli want to know that are there any catching system available for the statements which used by applications.When statement is created in server and again request is made for same statemets.does sql server return the same statements to applications.orit is necessary for me to implements my own catching scheme or something elsethanks in advancepandit |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-07 : 08:29:37
|
Not sure what you mean.When a statement is executed the query plan is cached. Futeure statements are checked against the cached plans and the lpan is used if the statement uis sent again.If you mean is the resultset retained in case the same statement is sent again then no. Reporting services and other clients will do something similar.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-07 : 08:35:53
|
And If you use Stored Procedure to get data the execution plan is cached so that next retreival will be fasterMadhivananFailing to plan is Planning to fail |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-07 : 09:50:38
|
And if you just want to see what SQL an application sends to the database, use Profiler.. |
|
|
|
|
|