Hi,

thanks for that great idea, it sounds like it would work and I'll give it a go.

I have made a bit more progress

It seems that as my fact table does not have a record for every single day, then I get the (blanks)

If I change my...

thanks for the reply.

It has almost worked, no error, but no value

Yes salesamountEUR is in the vw_GM_FACT table, that table(view) has a 'date' field which has a relationship to my...

Hi,

Actually it is more for performance, we have an 'old' vm at the moment 4 cpu 64gb ram etc. and want to upgrade to Ent edition and many more cpu's...

Actually, running my query at the start of this topic, and monitoring the PLE count, I did several select * from table which added another 5GG to the result and...

Thanks for the info, I actually recently inherited this server so have started examining and spotted this curious PLE setting, and had spotted the min/max being the same, I've changed...

thanks for replies, yes it has a clustered index.

thanks for the reply.

We are using SQL 2008 R2.

I shall experiment with a full reload from scratch every day rather than just updates.

As each table has a timestamp as well...

thanks for the reply.

Unfortunately, I've already examined that option but we cannot really change our erp system easily, so I hoping for an easy 'timestamp' comparison rather than comparing all...

thanks for the reply, but scd type 2 won't help me as the change will normally be in the fact table.

for example the use updates an order to change the...

I think my confusion came from this scenario.

Tlog backup at 9:30 and 10:30 and a full backup at 10:00

The full backup at 10:00 contains transactions since the last full backup

I...

Hi,

Yes makes perfect sense, thanks.

thanks for the all the replies,

if no activity is performed for 12 hours (overnight) then does not seem make sense to perform 24 tlog backups with no real activity. so...

That is where I am confused, as I thought that a FULL backup which does not perform a Tlog backup as such, does affect the transactions so there is no...

Thanks for the info, so is it that when a full backup is done that transactions will appear in the destination server, or for example, if tlog backups are done...