Browse by Tags

• dts
• join
• kill
• kpid
• performance
• processes
• rollback
• sp_who2
• spid
• sql server
• statistics
• sysprocesses
• table
• transaction log

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
06 May 08 01:02 AM | SQL Master | 2 Comments   

This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure Read More...

Filed under: sql server, spid, transactions, transaction log, processes, kill, rollback, sysprocesses, kpid, sp_who2

DTS package, how will optimizer treats the transactions?
02 August 07 05:52 AM | SQL Master | 2 Comments   

With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked. No transaction related Read More...

Filed under: performance, table, statistics, join, dts, transactions