good feedback.

If you don't mind do also gives the SSQL function and how its used - we may be able to help with it.

no need for Memory Optimized.

example

create table abc

(id int)

create clustered columnstore index CCI_abc on abc with (data_compression = columnstore)

no issues - but if you install Developer edition that is either a non prod server or you are breaking licensing terms.

Developer is not a downgrade at all - can...

If you license your box for SQL Enterprise and if you have software assurance costs do not increase with virtualization. Without SA or with SQL Standard then yes it does...

great - do get back to us with performance stats - although as mentioned before doing it SQL alone would also work.

with this you should be able to process all...

I'll see if i get time to do that over next few weeks

will be able to test both with SAN based servers and with PC based SSD and SATA

For your example you would be much better off, in terms of performance, by having an update followed by an insert:

UPDATE p 
  ...

it is working as expected - you are matching on product name - "TEA" - no record exists so both are inserted.

Note that the error would happen even with a...

can you post the full code - in pm if required - it does look ok and I dont see an error on its own

this is a example based on your own code

Define the output columns as required, add the required variables as read only variables and within the script add the following code

from...

Yup - I did that in a few cases where squeezing any amount of time...

Note that the domain account in this case should be a GMSA/MSA account - not a normal user account.

If this is not the type of account you created/used I would...

good to see that at least 2 members did understand what I was stating about count(*) vs count(1).

Brahmanand stated that "count(*) would need to read all data from the table"...

from my personal testing over the years splitting onto 4 files even if they are on the same destination disk will normally yield best results than 1 or 2 files...

its not for all things - I have a particular case on a DB that I am working at the moment.

big table - 150 Million records -

Most common sql on...

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