Translate

Monday, November 30, 2015

How to Avoid CXPACKETs?

CXPACKET is one of the famous wait type that database administrators are experiencing. Before moving into the details of CXPACKET wait type, - See more at: http://www.sqlshack.com/how-to-avoid-cxpackets/#sthash.lnQI7Ouh.dpuf

Eight Types of Slowly Changing Dimensions (SCDs)

We typically talks about three SCDs which are Type 1, Type 2 and Type 3. In Ralph Kimball and Margy Ross Third edition of the Data Warehouse Toolkit book, they talked about eight types of SCDs.

image