Gail Shaw thank you for the link.

You say that the update statisctics trigger on SQL Server 2005 fires at 20%.

Do you mean that this auto update statistics trigger only updates...

remember one thing.

after i update the statistics the query is very fast.

like

select * from diarioliq

where dataliq = '2011-05-16' = 1 sec.

if no statistics are updated then

select *...

SELECT Liquidacao.CODLIQ, Liquidacao.NUMLIQ, Liquidacao.LANCLIQ, Liquidacao.DATALIQ, Liquidacao.VALORTRIB, Liquidacao.ANOLIQ,

Liquidacao.DESCPERIODO, Liquidacao.CODTLIQ1, Liquidacao.IMPTRIB, Liquidacao.CODDLIORIG, Liquidacao.TIPODLI, Liquidacao.CODCRORIG,

ISNULL(dbo.IMPOSTODESD.NUMIMPDESD, Imposto.NUMIMP) AS NUMIMP, Contribuinte.NOMECTB, Contribuinte.NIFCTB,

CCCredito.VALORCCCREDITO, SGTALiqData.NUMDU, SGTALiqData2.OrdemNotas, SGTALiqData.CODCR, SGTALiqData.DATAEXPIRACAO,

Liquidacao.CODANULA, Liquidacao.CODIMP,...

I undestarnd but still in 2000 that didn't happen and lthe table has only a few more rows...

I will post the query

I understand, what i don't undestand is way in SQL Serfver 2000 the update statisctis (auto create and auto update) worked so fine and they don't seem to be fine...

I went deeper and found more intersting things....

I was thinking that this had to do with rebuid the indexs, but may be not.

every time a run this command,...

yes, i know.

The auto_shrink is off in most databases but the problem is the same...

How can i encrypt it?

Differente city but only 3 km away.

By Car.

How often is this data exchange going to be taking place?

R: One time at the end of the day

Are both servers SQL Server (or will they both be SQL 2005)?

R:...

There is no connection between the two servers.

Or is it DTS and they SSIS better?

i have sent to syadav@rtwbvi.com

thank you

how can i attach?