Search Results | SQL Server Performance Forums

Hanging Transaction (very weird)

Thread by: dataninja, Nov 16, 2004, 4 replies, in forum: Performance Tuning for DBAs

Recently we have been experiencing a lot of blocking in our VB fat client / SQL2K application. Certain processes have "hanging" transactions which...

Deadlocking ADO...

Thread by: dataninja, Oct 26, 2004, 0 replies, in forum: Performance Tuning for DBAs

I am trying to troubleshoot some deadlocking issues we are having. There are a few stored procedures that are updating a table and they often...

MSDTC & Windows Server 2003

Thread by: dataninja, Nov 25, 2003, 4 replies, in forum: General DBA Questions

Does anyone know what the differences are between the MSDTC in Windows Server 2003 and Windows 2000? We are considering upgrading some web/app...

Intermittent Failure - Please Help

Thread by: dataninja, Oct 27, 2003, 8 replies, in forum: SQL Server DTS-Related Questions

This is beginning to drive me crazy... I have a DTS package that fails intermittently. I constantly get a variation of the following error message:...

Clustered indexes returning incorrect order?

Thread by: dataninja, Sep 11, 2003, 8 replies, in forum: Performance Tuning for DBAs

I recently came across an interesting problem. An application that I work on broke because data was not returning in the correct order. An ORDER BY...

SQL 2K SP3 Scripts

Thread by: dataninja, Apr 16, 2003, 4 replies, in forum: General DBA Questions

Does anyone know what the 7 scripts are called that are executed during the SP3 install? One of our SP3 installs ran all the way up to the last...

Index ScanDensity very low on new index?

Thread by: dataninja, Feb 27, 2003, 3 replies, in forum: Performance Tuning for DBAs

I have the following table in a database: CREATE TABLE [X] ( [XGuid] [uniqueidentifier] NOT NULL , [XID] [smallint] NOT NULL , [XFlag] [char]...