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 5 years, 10 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 5 years, 10 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 5 years, 10 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 5 years, 10 months ago by frederico_fonseca.

sample powershell script that I use to copy/move files from a drop folder to dev/tst/prod destinations - dev/tst are "copy" while prod is "move"

some of the functions called are in...

ARGHHHH.. Sorry Jeff - hit report button by mistake.

your question - can powershell use variables - not exactly like you do it on a storedproc - but you can query...

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned...

someone has changed the default value to 2048 - unless someone experienced has tested and determined that this value is the best for your system MS recomendation is to set...

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/

yes you...