Once you use trace flag and find out the deadlock transactions, you probably click right-away. (provided you understand SQLServer concurrency and locking). You can send that transaction to snapshot isolation...

Read only. It is right there. I don't usually answer this kind of question. Today is exception.

Leave the line PRINT @sql, comment out exec @sql.

To answer some questions:

1) do understand how SQLServer does Read Committed with a shared lock (dirty read, phantom read, repeatable read) before you read on. Read books by Thomas Kyte.

2)...

"tons of development time"?

SELECT name

INTO #db

FROM sys.databases

WHERE

name NOT IN ('master', 'model', 'msdb', 'tempdb', 'admindb') AND

name NOT LIKE '%ReportServer%' AND

...

I sure think so. It does not matter what title is called, VP of DBA or something else.

The demand for data and server professionals will still be there. The...

This is based on one serve host. If you want to run this script between server A and server B (and your backup files could be on either one or...

I don't know which economy you are in. Don't make everybody believe that is what a good DBA is worth. I say $150K. 75 you get a...

How much RAM do you have on this system? How...

You could read on a book to understand index, how index is made and why these types cannot be in "alter index online operation".

Yes, you are right. I have not come in here for months, just reading as new. I did not see his comments that he resolved the problem.

My point is people...

flyme4ual (10/14/2008)

---

Hi guys,

I'm seeing CXPACKET wait types in one of my database running SQL2005 which causing the CPU hit 100%. The server is 64 bit Windows 2003 with 8...

chileu17 (10/21/2008)

---

Sorry SqlGuru :hehe: I think I couldn't explain to you my question. I do understand your point, BUT how do I implement what you are talking about?More indexes?new transactions?I...

Query tuning, indexing should be done at least once at dev, at QA before pushing to production environment. The execution plan should be evaluated. If you are serious, you can...

Thank you for sharing the experiences.

Create snapshots, let reports run against snapshots off-hours would be a better solution in SQL Server environment for reports in general. I encountered the...

PG,

If you are saying you solve the problem by altering this system SP using SET ISOLATION LEVEL SNAPSHOT

=====================================================================

USE [ReportServer]

GO

/****** Object: StoredProcedure [dbo].[WriteLockSession] Script Date: 02/16/2010...