Ok thanks, something else is that the UDF is a table value function as shown below, would this be better as a view as I understand that TFs do not...

Still different am afraid

hi and thanks

The result set is not the same, but I will have a play around with it.

Thanks

Ah ok thanks

Yes thats what is happening, thanks. I tried filtering NOT LIKE NULL, but that doesn't work unfortunately would be a nice little feature if it did I think.

Thanks for that, seems it not best practice although would probably work.

Ok cool thanks for that, I will check out using log shipping with replication.

Thanks

The upgrade in Microsoft Axapta is all done through the application using a new language some kind of cross between SQL and C# and is auto generated by the application...

Hi Mr Mystery 🙂

The bottleneck is the fact that after an Axapta upgrade, which performs Drop and Creates rather than Alters, we find ourselves in a situation where we have...

Oh really I wasn't aware of that, can you expand on your answer?

Hi the DB is 200GB and is a Sharepoint content DB.

I am currently collecting perfmon stats, and it writes to a RAID 3.

I have checked the space in the log, and there is plenty at present.

This database does get replicated to other sources, what impact could this have on the vlfs in...

Hi - Yes this is what I was reading which made me query it. Our DB is 270GB with a 40GB logfile.

The...

wow - ok thanks.

Ahh thanks, the snapshot_isolation_state_dec = OFF and is_read_committed_snapshot_on = 1