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...

use powershell for that - easy in just a few lines.

see https://powershell.org/forums/topic/find-and-replace-strings-in-multiple-files/

Frederico, do you have any test case to support your speculations?

I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages...

again some basics - few options to do it - and not exhaustive for sure and if anyone has a "faster" method please supply it and i can test it...

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

I should not have had the need to do this - all the links that I supplied have this info one way or another and more.

small test case - 5...

the paper i mentioned does give some insight to what happens under the covers - I could not find their previous paper and that would give even further insight to...

for Archival compression it uses Microsoft XPRESS

https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-xca/a8b7cb0a-92a6-4187-a23b-5e14273b96f8

for columnstore compression the engine uses the vertipaq/xvelocity...

Columnstore index is a workaround for denormalised data storage.

follow basic data normalisation rules and there won’t be any place for columnstore indexes in your database.

not to mention - you’re...

I would still consider them good for history/audit tables as these aren't queried often - saving on space is what would really be important here, not speed of processing the...

I work with it on my shop as we have a huge CRM installation - both in users and db size (3 TB) - you have for sure to play...

a simple group by and max would give the desired result without the need to do a sort/numbering with row_number

ALTER PROCEDURE dbo.GetUniqueValueNames
@MessageProcessFolio nvarchar(75),
StartDate DateTime = NULL,
@EndDate DateTime...