Igor Micev (6/20/2016)

---

The LAG function is aimed for those kind of problems like yours. Have you saved you query using LAG, if so share it here. Someone may find a...

Make your variable string type.

Thank you very much, I will check indexes when we'll implement this feature. Now we have CPU stressed because we have a lot of processes running, so when we'll implement...

The main question is if it is possible to manage/limit processors used per database.

We have to add some logic to this data and this will penalize processor disponibility to...

Indexes are not an option, because these 700K transaction are about 600K inserts and 100K deletes.

It is on our own server.

Hi, have you found any solution?

I am having same problem