just to clarify

will the query plan only be cached when the data in the query is consitent? so each time the data changes the query needs to recache?

that is unlikely

rows are added continually through out the day to several of the tables involved in the query in question

thanks for clearing that up 🙂

Thanks for the help

crashdan (9/5/2012)

---

It sounds like you are looking for 2 different things. one to move data to another...

thanks for the replies

i obviously still do have options with replication, triggers and such as mentioned

one more question, if i am using all of these processes will the performance of...

ok perhaps replication isnt what i need

it seems like more of a dev / back up / disaster recovery method

I am looking into ways of moving data into a...

ahh i see

so you mean its good to prevent someone being able to go into the reporting server and changing data where as the data should be changed in the...

reporting data could change from time to time, why would you need to prevent this?

sorry i dont really understand exactly what replication is all about

CELKO (8/31/2012)

---

The real goal is to get rid of the trigger completely and replce it with declaraitve code. We do have DDL or specs, so we cannot help...

thanks the reply

brilliant mate thanks for taking the time

anyone used these books?

http://www.amazon.co.uk/Training-Kit-Exam-70-462-Administering/dp/0735666075/ref=sr_1_1?ie=UTF8&qid=1345924071&sr=8-1

do they have practice questions in?

do think think i should do the exampls in order? 461, 462, 463 or doesnt that matter?

i ask because its...

cheers

how long have you got to take the exams once you have bought them do you know?

do you know if there are any practice exams anywhere?

thanks a lot for the replies, very informative

i'll leave the join types alone now but very good to know how it all works

thanks again