as you state your table is partitioned maybe you can switch out each partition onto a staging table, convert the table (repeat for all partitions, one table per partition)...

• This reply was modified 2 years, 11 months ago by  Vince Poirier.
• This reply was modified 2 years, 11 months ago by  Vince Poirier.

I don't think you could use Row Compression on a ColumnStore...

It's already...

• This reply was modified 2 years, 11 months ago by  Vince Poirier.
• This reply was modified 2 years, 11 months ago by  Vince Poirier.
• This reply was modified 2 years, 11 months ago by  Vince Poirier.

Thanks for the answer,

We already have views on top of our tables, so it would be easy to do.

But that would serve no purpose.

The main goal would have been to...

Thanks for the suggestions...

I don't really need to implement a new mechanic here though.

I already have a mechanic that reruns what needs to be.

But I have multi thread packages that...

I need my child packages to run in parallel (multi-threading)...

They're loading lots of data and I can't wait for one to finish before starting the other.

I've tried that and the...

Here is some SQL that illustrates my problem :

DECLARE @FactAlpha TABLE (
    FactAlphaID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY CLUSTERED,
    DimTimeID INT NOT NULL,
    DimInstrumentID...

Thanks very much Alan,

This is very useful and explains a lot.

I now have eveything I need to convince the DBAs.

Of course we will also make more tests in that direction.

Thanks...

That said, I would consider adding a surrogate key (e.g. an identity column) and use the date and surrogate key as your clustered index keys. (Date first, surrogate key second)....

Thanks for the fast answers !!

The temp table would work but I want to prevent DDL as much as I can.

The ROW_NUMBER() OVER (order by (SELECT NULL)) is awesome !!

Thanks...

Jeff Moden (1/6/2014)

---

Vincent_Poirier (1/6/2014)

---

Jeff Moden (1/6/2014)

---

Yes... rename each table and build a synonym for each table using the original table name. Build an additional table for each table and...

Jeff Moden (1/6/2014)

---

Yes... rename each table and build a synonym for each table using the original table name. Build an additional table for each table and populate it with...