Question : I have a MS SQL Server 2014 database with large scale of data an lots of users; and […]
Tag: distributed-transactions
Four-part distributed Query issue from 2014 to 2008R2
Question : From a SQL Server 2014 RTM in our DEV environement, I am executing this query using a SQL […]
UOW’s: Relating UOW’s listed in MSDTC to SQL Server info
Question : We have some active transactions showing up in MSDTC that have been there for a very long time […]
Unable to begin a Distributed transaction
Question : Can someone help me to troubleshoot this error? Error:OLE DB provider “SQLNCLI11” for linked server “TESTSERV” returned message […]
ORA-02049 and ORA-02063 Errors
Question : Select For UPDATE NOWAIT is performed on a table by 20 processes in parallel The error below is […]
transaction across multiple databases – what is the overhead?
Question : I run the following update, which is one single transaction across 2 databases. Please note I have not […]
Does openquery use distributed transactions?
Question : Does openquery in SQL Server 2005 use distributed transactions? If so, in which cases does it? Answer : […]
Distributed transaction coordinator between SQL Server and Oracle
Question : I’m not sure about distributed transaction coordinator so please bare with me on this, I’m probably asking this […]
Where do Linked Server Queries get executed?
Question : I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB […]
Distributed transaction coordinator between SQL Server and Oracle
Question : I’m not sure about distributed transaction coordinator so please bare with me on this, I’m probably asking this […]