I can't find right now the newer link for row compression recommendation, but here's the old one.  Of course, if your system is CPU bound, rather than I/O bound, you...

While row compression...

FacilityID - Decimal (12, 0) - takes 9 bytes - better to use a bigint - 8 bytes so I would look at this particular column to see if...

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

• table...

Yeah, that's basically it.  Although "changes written to mdf" is "changes to mdf made in buffers".  The mdf pages do NOT have to be written to disk for the trans...

Issue this command first:

CREATE SCHEMA config;

As for when to use a cursor, I've used these:

For looping thru dbs, the classic sp_foreachdb (my souped-up version, I don't use the MS version).

For relatively complex processing where you...

I don't like the dual FETCH statements most people use for cursors.  It often causes errors when one cursor gets changed and the other doesn't.  I'd like your feedback on...

I've...

Thanks

(3) Data in memory (in a buffer) that is forcibly written to disk is said to be "flushed".  This does not mean any type of problem/error has occurred. ...

SELECT
    m.A AS original_currency, m.B AS posting_currency, 
    /*...,*/
    m.value AS original_value,
    COALESCE(m.value * cc.conversion_rate...

You will also need the date (at least), since currency conversion values change over time.

Hy Scott,

Thanks for your reply and useful advises, but what kind of filter i must put in the Where condition inside the Begin ?

i think that the field dostamp...

You don't have any WHERE condition in the SELECT in the loop.  Thus, so it's essentially random which row SQL will return.

Btw, don't use functions against table columns in the...

Yes.    Eirikur's version of DelimitedSplit8k is fast AND is an inline table valued function.   Everyone who can't use String_Split should get a copy.   Also, use of an...