what are you trying to do now? the previous script you had was inserting into a SQL table - I gave you the base script for that.

This one seem to...

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

while we are curious to see if the code is indeed doing what is supposed to do (Business rules may be correct) I decided to give an attempt at it...

I wonder if the query is really doing what you wish it to do or if there is a better way to do it.

first cross apply "explodes" the records -...

thanks for posting your attempt - didn't try to see if they had an error so apologies if what I'm posting looks similar

3 options - untested obviously as we don't...

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

and what have you tried so far? this is a pretty simple function that any SQL Developer should be able to replace with a CTE and outer applies

that is your problem - in order to use the command line you need to have SQL Server installed including Integration Services.

what is the error and are you running on a server or on your pc?

note that to run from the command line you need to have SQL Server Integration Services...

create the clustered index on the same partition schema - other indexes do not need to be on a partition but the clustered one does

yes.... at a high cost mind you.

see https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/use-hcc-this-service.html

and https://logicalread.com/2013/06/17/oracle-11g-hybrid-columnar-compression-mc02/

not for all versions of oracle

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

its not as easy as that - and maxdop should always be set and not left at zero or 1 unless for a particular server that has been tested and...

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

documentation clearly states that any date conversion to be deterministic needs a deterministic style specifier - '19000101' didn't had it

its a separate install - download from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

it may be because of the implicit date conversion.

try the following - but change the convert(date to be the same datatype as the corresponding start/end_date field

ALTER TABLE...

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

I would say it was setup incorrectly - the DB engine is the one that should have the SPN's.

As Sue mentioned download the tool and follow its recommendations

I assume you meant export-DbaDbTableData

could be done...

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