Thanks Michael, I realize this is a risky statement. Thanks for your sample. On the other hand I don't think there will be 5 million rows of data sent in...

Thanks for sharing this.

Piotr

Maybe try char(13) + char(10) - '\r'

Piotr

Hi,

Yes, this is one of the options. You can load everything to a staging table and then update rows that do exist in the target table and insert the rest....

Sorry, but it sounds to me like a bad design idea. If you want to return different rowsets (columns, data types) from a procedure depending on the input, how will...

Hi,

If you have code that references two databases on single instance, moving one of them to another instance will likely cause troubles. You will have to look at linked servers...

Great 🙂

@piotr: yes, but with the EXECUTE as you enter the realm of the permissions and how they are chained. Imagine any user was able to use execute as...

Have you tried creating the trigger with EXECUTE AS clause? You might try to run it as sysadmin or some other login that has access to relevant databases.

Regards

Piotr

Why don't I see then actual rows counts? 🙂

Piotr

Thanks, good question.

Piotr

Maybe you can denormalize the structure a bit, which will make some of the queries simpler as well. You can put sum of payments to the Members table and Update...

It would be better if you posted actual execution plan, not the estimated one.

If I may ask a few questions:

Is stg_upfront.TotalValueUSD a varchar field? Why?

Why do you exclude scientific...

Hi,

Yes, ALTER causes recompilation of the procedure. This could have caused different execution plan to be generated, which works good now for the data the procedure works on.

Regards

Piotr

Hi,

This may have something to do with new behavior of the DBCC CHECKDB, which creates internal snapshot of the database. To disable snapshot creation, specify WITH TABLOCK option, but then...