Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jyskebank

    Does SQL-server cache inner SQL ?

    Regarding the last part about the 'manual' selection... I am concerned about the performance, which is why I want to make the subquery compile and run only once. - By "'manually' select" I mean, that i'm running the subquery as a seperate query, using this result to generate the SQL...
  2. jyskebank

    Does SQL-server cache inner SQL ?

    Thank you for your quick answer. My question however was ment in a more general manner, unless I have misunderstood your answer. I am aware of the conditions mentioned in your answer, and there should be plenty of memory for the caching. My question was focused on the SQL-servers ability to...
  3. jyskebank

    Does SQL-server cache inner SQL ?

    I'm creating a solution, that several times need to make requests to my SQL-server. These requests are in several occasions based on the same returned recordset, so I need to know, if SQL-server 7 caches an inner SQL seperately from the outer SQL? Ex. select * from A where ID in (select ID from...

Part and Inventory Search

Back
Top