what scale is the int in SSIS, there are 5 maintypes INT16, INT32 and INT64 plus the Unsighed versions (UINT32 and UNIT64)

An Int16 can only hold numbers upto +/- 32767,...

I have no Idea why a rebuild would do this, as I would have thought the addtionaltwo entries for the the IN_ROW and LOB data would be there as soon...

What Data type is the SSIS variable TeraDatacount, and how many rows are you pulling through.

Hi,

I would start by reading this article first, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Its got a great String splitter function.

ColdCoffee,

I like your solution.

I pushed it to run over the largest dataset I could think of with every month between 1753 and 9999 and it returned in about 2...

Glad to Help, and best of luck, if you have any questions drop them into SSC I'm sure people will be happy to help.

By any chance did you update one or more of the XML columns, as these (from memory) are stored as LOB's so pointers would be created to them hence the...

So we're talking about 200,000 rows of data,...

Thats a tricky one, as anthony says youll probably need a full extract to do the deletes.

Out of curiosity how many rows of data are we considering here in the...

Personally I would have a preload Table that gets truncated at the start of every load, then once the file is loaded into this table its is merged into the...

Sorry I got end of the wrong end of the stick. I thought you were new to DW's.

I'll have to read up on MDW as it looks pretty interesting.

I would first suggest reading up on Data warehouses and Star Schemas.

then write down what you want to measure and how you want to analyse it.

I used to Use DBCC SHOWCONTIG quite a bit for looking at fragmentation but have replaced that with the SQL statements against DMV tables and functions, especially for partitioned tables.

DBCC...

Koen Verbeeck (12/14/2012)

---

Jason-299789 (12/14/2012)

---

What exactly are you trying to do?

Also the SCD will not recognise Primary keys on the desitination table as Business Keys as they are not guaranteed to...

What exactly are you trying to do?

Also the SCD will not recognise Primary keys on the desitination table as Business Keys as they are not guaranteed to be identical, where...