Other SQL Server Blogs around the Web

Browse by Tags

• 2005
• 2008
• 3314
• 9001
• 9002
• active
• article
• begin
• clustering
• connections
• cursor
• dmv
• end
• enhancement
• enterprise
• error
• errorr
• isolation
• issues
• kba
• level
• locks
• log shipping
• maintenance
• msdtc
• new features
• performance
• servers
• services
• sql server
• stored procedure
• sysprocesses
• tsql
• X64

• TSQL to get list of operations in active transaction of the current session

  SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever... Posted Jan 27 2010, 07:46 AM by <P>SqlServer-QA.net</P> Filed under: dmv, sql server, tsql, transaction, new features, active

• FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: An ongoing MS DTC transaction is... Posted May 15 2008, 03:14 AM by SSQA.net Filed under: sql server, transaction, 2005, kba, msdtc, issues

• SQL Server: Quick way to find Active & idle connections on a SQL instance

  Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system... Posted May 02 2008, 04:32 AM by SSQA.net Filed under: dmv, sql server, tsql, connections, transaction, active, sysprocesses

• SQL Server 2008 - TSQL behavioural changes and enhancements

  As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should... Posted Mar 31 2008, 02:00 PM by SSQA.net Filed under: begin, sql server, performance, 2008, tsql, transaction, enhancement, article

• FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Jan 11 2008, 09:35 AM by SSQA.net Filed under: sql server, transaction, kba, maintenance, errorr, 3314, 9001, 9002

• SQL Server MSDTC service - do you need it or not?

  MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent... Posted Oct 11 2007, 07:02 AM by SSQA.net Filed under: sql server, transaction, kba, services, msdtc, clustering, servers, begin, end

• FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Aug 25 2007, 04:30 AM by SSQA.net Filed under: sql server, transaction, kba, isolation, level, cursor

• FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Aug 23 2007, 06:25 AM by SSQA.net Filed under: sql server, X64, tsql, stored procedure, transaction, kba, enterprise

• FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Aug 22 2007, 04:05 AM by SSQA.net Filed under: sql server, transaction, error, kba, log shipping

• TSQL to identify the transaction with the most locks

  SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Posted Jul 31 2007, 09:25 AM by SSQA.net Filed under: sql server, performance, tsql, transaction, locks