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, 9 months ago by frederico_fonseca.

without changing the logic of that task it would be possible to change it to be a script component (source) and instead of doing the inserts adding the values as...

SSRS is not free - it is part of the SQL Server license you bought.

From a licensing point of view you can install as many instances as you wish on...

New CE can do quite bad stuff.

One case I had, huge CRM database, had one simple query -- select 6 columns from tbl where field = 'abc'

table with 200 Million...

why don't you try it and look at the resulting explain plan? That should have been your first call before asking on forums.

but answer would normally be yes it will...

I would also try the following. it may be fast enough to allow connection

change the service so it has the -mSQLCMD flag

create a small cmd file with

net stop service

net start...

Just thinking... are you starting sqlserver from the command line or are you changing the service properties and (re)starting the service?

if on the command line then that window will indeed...