in SQL the only thing that allows something nearer regex is patindex - but it is still not full regex.

give that one some time as it can do things that...

did a bit of changes to your code - untested and may have typos so if you get any error that is most likely why

there are a few comments on...

same thing

you can do it 2 ways

1 - when you are posting you can select the option from the menu that says "insert/edit code sample" - this pops up a...

you may not need one, even if MS tells you there is a missing index - many times you add those and they either don't improve performance or they aren't...

Here is the complete code:

I a now using coalesce so that extra query inside when exists is removed. I do not see a huge performance gain though.

code deleted as...

• This reply was modified 6 years, 1 months ago by frederico_fonseca.

when posting code can you please try and format it better and use the "insert/edit code sample" option so it is easy to follow it.

as all that code is repetitive...

if format is always the same you will need to use a bit of substrings and concatenation

extract following blocks

• year
• month
• day
• time

then concatenate year-month-day  time with between day and...

have a look at these 2 links to see if they help.

https://stackoverflow.com/questions/10232084/attunity-ssis-not-available-in-ssis-data-flow-tasks

https://stackoverflow.com/questions/54683977/attunity-connectors-are-not-showing-in-ssis-for-vs-2017-sql-server-2017

Thanks! That's what I thought but I wanted to make sure if i'ts not any different. Would CDC method works better for Very large database(2TB)?  Does Informatica handles better...

CDC can be used in AWS RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html

but CDC does not push anything - just helps a ETL job to identify what has changed.

you don't use CDC instead of ETL - CDC IS a method that can be used as part of a ETL Process

I'm sure you can do a sample create table and insert statements of sample data to help us help you.

field names don't even need to mean anything so no excuse...

Alejandro, if you read the documentation you will see that the example given is indeed on the MS documentation as an option to start SQL Server on single mode and...

what are the reasons for not using backup/restore?

but the copy database option, using SMO, will copy all db objects - data will be the same with likely exception of timestamp/rowversion...

This will explain what it is.

I don't think full plan has columnstore segments data on it - but to confirm we would need the full explain plan file (to...