Thanks, i've already seen this links before and practised some of the suggestions. My question is that can i make my queries run more faster, since they are online...

Lowell (4/2/2013)

---

As Sean has identified, all we can offer is vague advice unless ou have some details we can look at to try and help.

here's a quick list of some...

Guys, i'm getting more confused here,

which way i'm i to go?

Thanks Kevin, are u suggesting i use Triggers with a unique id?

You said you have been doing something similar, can u please shed more light

Thanks

Tim

lol, your reply made me laugh, i.e the its not worth it part.

Alright, i'll google replication and see what i can come up with.

thanks

Tim

This is the query

declare @ids varchar(8000),

@Station nvarchar(4),

@BeginDate datetime,

@EndDate datetime,

@BeginTime nvarchar(8),

@EndTime nvarchar(8),

@BeginTime1 nvarchar(8),

@EndTime1 nvarchar(8),

@BeginTime2 nvarchar(8),

@EndTime2 nvarchar(8),

@Scheduled int,

@Duration int,

@Program nvarchar(355),

@product nvarchar(6),

@brand-2...

Thanks Koen,

I did this but its complaining incorrect syntax near the keyword 'AS'

MERGE Products AS TARGET

USING UpdatedProducts AS SOURCE

ON (TARGET.ProductID = SOURCE.ProductID)

--When records are matched, update

--the records...

Thanks Kingston,

Sorry that i'm getting to you this late, this are the DDL and the sample datas:

--This is the source Table

CREATE TABLE [dbo].[LagosTelNov](

[DATE] [datetime] NULL,

[TIME] [nvarchar](max# NULL,

[LENGHT] [float] NULL,

[BRAND] [nvarchar]#max#...

Thanks Kingston,

Sorry that i'm getting to you this late, this are the DDL and the sample datas:

--This is the source Table

CREATE TABLE [dbo].[LagosTelNov](

[DATE] [datetime] NULL,

[TIME] [nvarchar](max) NULL,

[LENGHT] [float] NULL,

[BRAND] [nvarchar](max)...

Thanks Guys for your helps, i'll check on what u posted and get back to u. Thanks

[quote-0

Has this application been upgraded from 2000 to 2005 on that server? If so did you reindex and update the stats?

Also 2 GB on a prod server is quite...

I have thousands of stored procedures running, so i would not...

cpu is 2ghz, memory is 2gb, harddisk space 500gb, virtual memory starting at 2038 and ending at 4000mb. So any suggestions please.

Thanks

Hope you intend to post the solution so that other who may have a similar problem can learn from you. In other words give back to the community...

Thanks Jeff, i already solved the problem and only forgot to post it here. Thanks so much for your reply, it shows u care. I appreciate.