Ok, thanks to both! One more question, if you have time: if I enclose the above SELECT logic in a CTE and then use the CTE for my SUM aggregation,...

Thank you Phill. What I know about the client is as follows:

- it's a SCADA software (Citect SCADA)

- the SQLExec is using ADO.NET behind the scene

- the four SQLExec are...

That is: the Standby PC does not collect data, but it is still there for reading purposes.

you simply remove the ability for read-only querying...

Unfortunately operators have the option to query the database...

TheSQLGuru (5/22/2014)

---

One would figure that there is a high probability that real-or-near-real-time data transfer was required or they would not have used Sync Framework in the first place. So...

TheSQLGuru (5/21/2014)

---

I agree that synchronous database mirroring is probably the way to go here. Decent hardware should be able to keep up with 30 actions per second without much...

Thank you all for your interesting suggestions. Maybe the CONTEXT_INFO solution is the best in my case: separate logic for AFTER DELETE is good, but in my case the logic...

You are right, that's a good solution. I've only an additional problem, I must think of: as you said, it is a bulk delete. This bulk delete will be run...

Thank you for your answer Jeff. This was also one of my thought but there are 2 cons:

- 10gb limits as of version 2012 express and the database should store...

Thank you all for your suggestions. Short description of the system:

- the aim is production tracking

- there are 2 PCs each with its own MS SQL Server and a...

Hello Mr Eiriksson,

I plaied around a little with the PERMISSION_SET and the UNSAFE setting gets the best result, i.e. what you can read in my previous post (the other PERMISSION_SETs...

Thank you all for your answer:

HowardW (11/20/2012)

---

20 transactions per second sounds quite a lot for non-pooled connections though, you'll be adding quite a lot of overhead by doing one log...