Denormalizing the database will improve query performance simply because it has less number of joins. The more the joins, worse is the query performance. That's why most of the DW...

Hi,

I would more information before suggesting something..

1. What is the approx db size (in terms of no. of fact rows) in each quarter?

2. How much historical data is required?...

Hi,

I presume you are using SSAS 2005. It supports Measuregroups, meaning you can have multiple fact tables in your cube with different granularity.

You can have a single dimension, say,...

Hi,

If you are still searching for an answer:

You need to learn SSAS (Analysis services) 2005 to build your cubes. You can make use of the wizards which would guide build...

You can consider using a Synonym. For more info:

http://msdn.microsoft.com/en-us/library/ms177544.aspx

Make sure you give a fully qualified name for the table.. something like:

[databasename].[dbo].OrderDetails

Hi,

You can try this as well:

UPDATE A

SET A.PDate = B.PDate

FROM OrderDetails A INNER JOIN PartsPricing B on

(A.PartID = B.PartID)

Excellent article. All simple but effective tips.

Hi Greg,

I see your point. Before we start exploring the real complexity, we would like to know the number of codes involved and tasks used in the packages.

Thanks,

Vijay.

Hi Mike,

First of all, many thanks for your helping hand. Our packages are stored as dts files and not stored on sql server. So, your application may not help us....