View is defined as below

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[Order]

AS

(SELECT Convert(VARCHAR(40),rs.order_id) ...

As Sqlguru suggested SSIS is very handy tool for synchronization. It is very efficient and fast. I have tried it personally.

(dont know why his daughter needs funding as he is...

Hi Grant,

I have attached the execution plan now. Im very new to performance analysis and unaware about saving execution plan. Appreciate your smartness in communication

Thanks

Hi Grant,

Reason we are using view is to achieve data synchronization between old and new database.

Order view contains 3 tables order,shopper,user and total of 30 columns.

order table...

Hello,

I have tried executing stored procedure and dynamic query under the same ansi setting. Execution time is 1min:05 seconds for stored procedure and 30 seconds for dynamic query.

Im querying...

Lowell,Grant,Barry,

I will try lowell script tomorrow with same ansi setting for stored procedure ( has some parameters)and dynamic query. I will aslo try adding index to the temporary table and...

Like Jack said comparing two different database can be anything.Schema,data or some time change in structure. I assume you might be capturing the difference and reporting the user. If...

Hi Adam,

Yes I share your concern. Do you any other alternative in your mind?

Ta

Hi Adam,

Thank you for your suggesstion. However, we cannot put the trigger on Live server. This is one of the reason for using the replication. I have used the replicated...

Hi Gail,

Thank you.

My manager found running query on that table is slow he just did try follwing t-sql

select count (*) from tentable

select * from tentable.

It just basically a...

Hi Gail,

Can you give me some direction how to carry out further analysis. I will also look in to the website (I'm already a member) you marked in the...

Hi Gail,

It take long time to retrieve the rows and display it on query analyser. Application that using this database is reporting performance issue often everyday. I have now setup...

There are not many long transaction. I have found that this particular table (73 columns) takes long time to retrieve more than 1000 rows. It does quickly retrieve top 10...

Thank you. Will look in to that in detail.

ta

An update.

Lock has been caused due to continous synchronization of large volume of data which generates the lock if we try to do future synchronization process immediately before it had...