Thanks but the query is fine (and the clients wouldn't be too happy to see this particular statement posted on the internet). We 'solved' the...
Hi I have a statement that selects data from a number of tables (left and inner) which has a DISTINCT clause in it. When run it returns one row....
In case anyone is interested ... we finally tracked it down. The time is taken up by the .net to com interop. Outside COM+ it is barely noticeable,...
Hi<br /><br />The issue arose from an investigation into slow response times reported by a client running a fat client on a 3 tier system with a...
Once again thank you for your help.<br /><br />I've checked the documentation and written a test noddy and am now certain that the transactions are...
I've just had a read of the links and it suggests that the serializable isolation level is only enforced if you utilise the MSDTC transaction...
Thank you very much ... I really appreciate your help
Hi,<br /><br />It's a general question to see if anyone has come across this problem (and hopefully knows how to solve it).<br /><br />We interact...
Separate names with a comma.