That seems a little unusual as we've never had a problem with the install of SQL Mobile.

However, what we did notice when we started using it was that there was need...

No need for line by line processing - it is slow and you have alternatives.

Seeing as you haven't given the whole query, I am surmising that there is something not...

select

         col_name

         count(col_name)

  from

       customer

  group by

       col_Name

Something like that will give you which ones have duplicates -...

Good point Rudy.

It might be worth explaining to Richard that existing indexes can become a little less useful if the statistics surrounding the data usage get out of date.

SQL...

Richie

Try this

CREATE trigger POPHDDelete

on POPHD

after delete,update

as

insert into Xpophd

    (

     col list

    , DELWHEN

    , DELWHO

    )

select

      col list

    , current_timestamp

    , system_user

 from

      deleted

Stephanie alluded to it...

Forgot to mention also that if the stored procdure uses multiple queries to get its results, break it out into query analyser and set some timings between each query.

This...

I would recommend that you look at the execution plan for the query and try to determine which tables - if any - are doing scan operations instead of seeks....

That would be because that is exactly what you are asking it to do.

In you where clause for your update statement, your only join condition is that the IDs match.

It...

What we did was change the way we set up synchronisation. We utilised the pre computed partitions using partition_options = 3.

However, this comes at a cost to subscriber functionality....

I don't know of any books that talk about this - not that I've ever looked. We have tended to go by what we understand the documentation is telling us...

I would only add to Andy's comment about performance in that you should definitley try tp understand performance implication prior to any rollout.

Our experiences have shown that a non-performant...

It seems to be that the records at the publisher need to have updates on either the filter or join columns (as layed out in your replication scenario) before the...

Oops, forgot to mention that sp_helptext is the stored proc for getting the source of your views and procedures.

You might want to include User defined functions as well...

Sounds complicated to me as you would need to parse the source for the procedures or views to determine column and table names.

Once you have a list of those, you...

Great article, great editorial.

I'll be sharing both with my work mates.

Must be time for that holiday (and I would NEVER take my technology with me).

Thanks Andy and Steve. This is...