Package stored in MSDB runs slower while executing in DEBUG from SSDT

Customer had opened a case with Microsoft Customer Service and Support (CSS) SQL Support to find why Package stored in MSDB runs slower  while executing in DEBUG mode from SSDT comparatively to the package stored on the file system.   For a specific customer scenario, package imports about one million rows. If the package is stored on the…

0

How to develop WinDbg extension DLL

How to develop WinDbg extension DLL? A WinDbg extension DLL is set of exported callback functions for implementing user defined commands to extract specific customized  information from the memory dump(s).  Extension DLLs are loaded by debugger engine and can provide extra functionality of automation tasks while performing user-mode or kenrel-mode debugging.  An extension DLL may…

1

Max. Number of servers a transaction can be propagated using DTC

The Issue: We recently worked on a customer issue, where a distributed SQL query was executed in a single transaction using  SQL  – SQL   as linked server. The 2nd SQL Server has about 80 linked servers defined to 80 different remote SQL Servers.  The distributed query updates a table, which has update trigger defined.  The…

0

Accessing rowset after committing a transaction

The rowset full functionality is either preserved or rowset enters into zombie state, after completing a transaction. If the rowset needs to be preserved after committing a transaction, to add or fetch new rows, delete or update existing, the cursor type must be explicitly set to use server side cursor in conjunction with preserve rowset…

0