Hi Gail,

Thanks once again your quick reply.

I got your point and will go with selective index maintenance optimisation by using script NOT WITH MAINTENANCE PLAN.

You are right probably my some...

Hi Gail,

Thanks for your quick reply and providing me URL's.

You suggest me to use Point 2. in my previous post which is mainly use the script and do index maintenance.

This...

Thanks a lot all,

After going through your discussion I came to know that I have 2 options which are tsql and SSIS script component.I will explain both options to client...

Hi All,

Thanks for your replies.

We are using SQL Server Standard edition and currently we are using staging table.

I have brought down transfer time to 15 min but management are asking...

Can you please let me know what are other solutions?

What is the trickle feed?

Thanks

Nick

Thanks for your advise.

On price table it does :

if Price Date exists with different value then moves data from Main table to archieve table

then Updates with new values on Main...

We having same issue in our one of the production box and users are complaning that connection is closed.

Is there any solution for this?

Thanks

Nick

Primary key columns are Id & Date(compsite key)

Thanks

Nick

Sorry about that,

This is equity price table and it contains many combination and it would be very hard to give all cases.

You can imagine that we are storing 100,00 equity...

declare @Prices TABLE (

Id int NOT NULL,

Date smalldatetime NOT NULL,

CreatedDate smalldatetime NOT NULL,

Price float NOT NULL,

Currency int NULL,

LastChangeDate smalldatetime NULL

)

insert @Prices

select 1,'20030101','20090203','9.48',6,'20030101' union all

select 1,'20030102','20090203','9.48',6,'20030102' union all

select 1,'20030103','20090203','9.48',6,null union all

select...

Thanks for reply.

Your code updates both NULL values with same max date which is not I am looking.

First Null value in table should be updated with LastChangeDate=20030102

******

Second Null value...

Thanks for your reply.

I think this is what I am looking but could able give bit more details about your code.

What I understood that before running Processing task it should...

Sorry,Probably I was not clearly gave my requirements:

Processing data can happend any numbers of time in a given day but Transfering to other database can happen only once/twice a day

I...

Can you please elborate what do you mean.

Currently both are using TCP/IP and ANSI_NULL is on.

Thanks

Hi,

Thanks for quick reply.

But the store proc returning total around 18,000 ods no more then that.

This is very stragne behivaour i have seen first time.

If anyone come across same situation...