its not per instance you only license the VM (or physical server ) - for SQL Standard on a VM environment you license all vcores on that VM (minimum of...

possibly use a execute sql task instead of a dataflow - resultset

pass this resultset to a component script and for each record retrieved create a new file and write the...

not being able to see the history may be other permissions being set or SSMS having issues.

or... too many jobs on the server and the history for the jobs he...

are all files the same format or different formats?

and when you say they are delimited (space in this case) with double quotes as field delimiter - is that really correct...

error is pretty clear - produit.sales.SalesOrderDetail_2014 is not partitioned - the image you posted is for the table sales.SalesOrderDetail

if your partitions are yearly and if you archive onto 1 table...

it does help to read the manual

$A = Import-Csv -Path .\file.csv -Header 'column1', 'column2', 'column3'|select column1,column3

it all depends on the requirements matrix that you should have done already - that will give you a hint of what you may need.

its not enough to say that...

no need to do it - that comma is part of the data and unless you have a business rule that requires its removal you should leave it in.

In posh...

how have you determined that you need in memory tables? can you supply the requirements matrix that you used for it?

unless you are looking into thousands of transactions per second...

and second step - and sometimes the only one as what the "users" see does not necessarily reflect the underlying database - look at code that uses that db

SQL procs

Functions

View

and...

I have a question about the code being posted:

So you run an update, and if no rows were updated (reading @@rowcount), then you do an insert. What happens if...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

union all is what you need ... but not necessarily the way you were thinking about it

declare @Temptable table
    ( ID   ...

The whole retry loop could be removed in my opinion.  This is a basic upsert.  The variables used for flow of control are deterministic so the retry is not...

change the dynamic port to a fixed port - you can even set it to the current picked dynamic.

alternatively, and if you have this on a Domain, allow the AD...

so you are telling us that doing a

insert into archive_table
select *

from main_table where filtering_column = date_to_archive 

takes 5 minutes?

or that it takes that amount of time retrieving the...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.
• This reply was modified 5 years, 8 months ago by frederico_fonseca.