OK - thanks guys

I'll see if I can do a trace and set up the recompile counter.

I'll see if I can post the proc today and read up on the...

thanks for your replies -

what do you mean by recompiling for each row updated?

Are you saying that the query plan is being re-evaluated for each time a row has been...

I have also run into something strange - not attributing it to the full-text indexing but now wondering ...

I addes new statistical columns and new indices as recommended by DTA...

I have just run into this very problem and putting the table name enclosed by [] works including reserved words as tables names and spaces in table names.

I use a...

I've managed to do this - it appears that in SSMS the _dta_index% and _dta_statistics% all appear in the Statistics tab of the table properties tree.

Any the problem is that...

thanks TheSQLGuru

thanks guys for your comments.

Read the MS reply and it makes sense and its bears out what some other people have said on this site.

Have to stick with the sql...

Found my answer.

Apparently expected behaviour - have a look at this post.

http://www.sqlservercentral.com/Forums/FindPost275092.aspx

Greg - thanks for the information.

I have been using the processor: %usage, buffer cach hit ratio and cache hit ratio - to try and determine if I'm low on memory.

Also...

John, thanks for the reply. No problems with what you have said - I guess I'm in transition having 15 yrs with another db and trying to translate what I...

John, thanks for the prompt reply.

No the cpu is not that high but when I run the trace it was, however memory did not increase. And yes the system is...

Hi All,

solved this problem using the remote syntax to force the remote query to be completed on the remote host.

UPDATE dbo.s9ge

SET s9ge.institutionname = ( SELECT...

thanks for the replies - found the problem. Service providers restored the wrong backup!

Hi All again. Update on where I am as I still need exampled help please.

I have successfully converted 3 DTS packages (17 steps into one SSIS package that runs and...

Rajiv - thanks for your outline. I am not at this stage looking to replace the excel spreadsheet they have - it works and the pivot tables work OK.

I am...