Monthly Archives: February 2007

Debug Distributed Transactions Error in SQL Server

In Windows 2003, the security was tight on MSDTC service. you will get the following error if you start a distributed transaction agaist a linked server: Server: Msg 7391, Level 16, State 1, Line 2The operation could not be performed … Continue reading

Posted in SQL server | Leave a comment

Performance issue for recursive queries by CTE

Common Table Expression (CTE) is a new feature in SQL Server 2005. One of its use is that it can used to create recursive queries easily. However, the performance is not so attractive comapred with plain T-SQL. Let’s take an … Continue reading

Posted in SQL server 2005 | Leave a comment