Hi guys,

thanks for all your help, i have updated statistics on all the columns, I ran the query suggested by ChrisM and also the original query , both now...

sure, just finished running the exec sp_updatestat, all stats are updated on this DB now. Running the SQL now, will keep you posted.

Hi ,

sorry I don't have much experience reading execution plans. I told both looks the same based on the % figure on icons within both the plans (because they...

Ran the amended SQL but there is still no improvement. it takes exactly the same time (50 minutes) to run. Have attached the actual execution plan, looks exactly the same...

Hi guys,

thanks a lot, I'll try your suggestions today and let you know if there are any improvements in the run times, also welcome any other thoughts.

Thanks again

hi sean, sorry i am novice to DB so couldn't really understand what data movement means. You are correct the stats are stale. but i have a test environment, i...

hi sean,

sales_fact has 1 billion records, other 3 tables have less than 100K records

Hi, the stats were run 3 weeks back. i have attached the create table scripts for 4 tables. will paste the index soon.

Hi Gurus,

Sorry for the late reply, attaching the actual execution plan for your reference. The query was generated from a BI tool that's the reason why its got 3part 4part...

Hi Eirikur Eiriksson,

Thanks for your response

I've attached two SQL plans here, one is with product_dim and one without it. do let me know if you are unable to find them.

Thanks...

many thanks, table is quite big not sure how do i go about moving data into temp table and then back to original table. However i will try the batch...

Hi Jeff,

Thanks for the reply, our DB is in simple recovery mode. The complete task took 5 hours to complete on Saturday. Quite happy that everything went as expected.

The...

thanks a lot guys problem was confirmed due to SAN running out of disk

Thanks a lot friends, your replies have been very helpful.

The table is not partitioned because we use SQL Server 2008 standard so this version does not have partitioning feature. I...

Thaks djj and free_mascot for your replies. yes I will try to figure this out by noon.

Any idea how do I go about rebuilding the index on this table ?...