I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH
wait type.
The update is blocked by himself (using the sp_who1, I see the lock)
what can I do?

What is Datawarehouse and How can we take benefit out from it. ??

I have a POITEM Table which has just three columns
InvetoryID, DateofOrder, VendorID
I have under the same InventoryID ,multiple DateofOrders and VendorrID;s.
SO for eg here is a couple of lines of the data,

I have a data modelling challenge I need to store multiple values in
the attributes
of a dimension. The dimension I need to model is the Materials
dimension for each material

Can sombeody point me in the right direction. How can I convert a relational
database to a datawarehouse?
Thanks

I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an SQL
Server Analysis Services Server.
This works fine and I'm hapy with it, but some of my cubes contain dimension
properties, that only Excel 2003 can show, and my company's unfortunately

I'm looking at using checksum to check for changes in our data warehouse,
and have seen comments on the checksum not always being unique.
Just wanted to know how it is actually calculated to see if it is likely to
get duplicated checksums.

We have a table which data is over a million but less 2 billion. We define an
integer field to hold primary keys but we do not like to choose GUID or
IDENTITY.
Anybody knows any other simple ways to generate unique key?

how difficult is it to convert access tables to SQL that can continue to be
linked to an Access GUI.

We have an anomaly where over time the hierarchy of a dimension
changes.  With that, we are only allowed to have "1" hierarchy.  It is
basically an organization hierarchy where people get promoted, demoted
and change ranks over time.  The business requirement is to be able to

I'm looking for some advice/tips on implementing DW on SQL server with data
from Oracle databases. What are the common problems, best practices,
thingies like that?
MC