Wait what are you trying to do?  When you say the date should look like something that means you do want it in varchar format, why are you trying to...

you need to run the SSIS Service

This is not correct. The SSIS service does very little, in fact, and is not required for package execution. Have a read

Hmm..... I think this comes down to a case of use the right tool for the right job.  And being told to never use SSIS is just as silly as...

No there's nothing inherently wrong with negative values in a primary key.

If you wanted to find any you could run a query that would give you a list of all...

Sure, a negative value is just a value.

What is your exact concern?

Sure,

SELECT DISTINCT COL_ONE.TABLE_NAME, COL_ONE.TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS COL_ONE
INNER JOIN INFORMATION_SCHEMA.COLUMNS COL_TWO ON COL_ONE.TABLE_NAME = COL_TWO.TABLE_NAME AND COL_ONE.TABLE_SCHEMA = COL_TWO.TABLE_SCHEMA
INNER JOIN INFORMATION_SCHEMA.COLUMNS COL_THREE ON COL_ONE.TABLE_NAME = COL_THREE.TABLE_NAME AND COL_ONE.TABLE_SCHEMA...

Well can you just put a last modified date on the record and use that capture deltas?

Another possible option is to snap shot the entire data set at the start...

• This reply was modified 5 years, 9 months ago by ZZartin.

I used the Script to New Window feature in version of SQL Mgt Studio we have access to in the vendors cloud to quickly generate the DDL. I changed...

Why do you have the nocheck statements in there?

Is it that currently turned off on your actual tables?  Or is it a setting someone would have toggled on and off? ...

How much of the localization is being done in the ERP vs directly in the DB?  For example are dates stored in local time or as UTC time?  Similar issues...

I know how I've done it in the past (xp_CmdShell) but a lot of people poo-poo that idea even if they do poo-poo it because of bad information and resulting...

/shrug I think that the fact that dictionaries are maintained transparently in the internal guts of column store indexes vs having to maintain and join a lookup table by...

Columnstore would work by tokenizing and limiting the repetition of values. A simple example is gender. Say we have 3 values (M, F, Other). If we had...

Columnstore would work by tokenizing and limiting the repetition of values. A simple example is gender. Say we have 3 values (M, F, Other). If we had these stored...

Maybe you could explain what your actual use case is?  As has been explained column store indexes are not a magical solution that by default replace regular indexes.  How big...