September 30, 2014 at 4:46 pm
Hello
I have an existing SSIS that uses SCD on a rather large table. I am also migrating to SQL2014 Enterprise. My question is, is it possible to use SCD and Columnstore(CS) together? I know that I can drop the CS and add a business key then insert data. Then drop the business key and add the CS back. Would rather find a better solution. Thanks
John
October 8, 2014 at 8:55 am
I thought columnstore indexes were updatable in 2014:
http://blogs.msdn.com/b/sql_shep/archive/2014/05/01/sql-server-2014-updatable-columnstore-index.aspx
http://sqlblog.com/blogs/michael_zilberstein/archive/2013/07/01/49903.aspx
Wouldn't that take care of your updating the SCD?
HTH,
Rob
October 8, 2014 at 10:56 am
Rob thanks. That does help. I think that I will end up writing my own solution using the standard insert and update objects. It's not hard in my system to find the rows that modified verses new. Was trying to see if anyone knew a specific building object like SCD. Thanks
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply