You need to specify a lot more detail.

You say that the processing starts fast and then slows down. How do you know this?

Is the bottlneck on the client or the...

Sounds like a fragmentation issue with some system tables, or perhaps some kind of database corruption.

To me the best fix seems to be to simply avoid full scans of the...

We use subversion with Ankhsvn and Tortoisesvn.

No cost and very good functionality.

Are the actual query plans identical for the queries with and without UNION ALL ?

BOVA Systems (7/1/2010)

---

Here are the results of the ping -t command. NOTHING was running on the workstation.

Can someone explain to me what could be the problem that causes the...

I believe that you are inadvertently switching the input language between your desired language (UK english ?) and the standard US English.

Exactly how this is done depends on the OS...

winston Smith (6/30/2010)

---

ok, so im typing in Outlook. If i hold shift+2 i get the " symbol, shift+' gives me the @ symbol, etc etc. as expected.

then i open sql...

Your query causes a full table scan.

To get good performance the query should look like this:

select text from syscomments where id=object_id('dbo.ObjectName')

I would probably use:

select sum(rows)

from sys.partitions

where

index_id <= 1

and

object_id = object_id('[dbo].[BALEOD2009]')

Even if Microsoft has described the rows field as "approximate number of rows" I still have not seen...

Well, there are two possibilities:

1) There is a...

Shamshad Ali (6/29/2010)

---

My friend, I used following script to create Three non-clustered indexes:

CREATE NONCLUSTERED INDEX [IX_ProgramTracking_ProgramId] ON [dbo].[ProgramTracking]

(

[ProgramId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...

I have tried to reproduce your problem.

I am able to get deadlocks using the following script:

-- Create a test table with an index

use tempdb

go

if object_id('deadtest') is not null drop...

Shamshad Ali (6/29/2010)

---

I don't think that HINT will solve my problem, its locking at the first insert statement <Master table>, when it returns the ID then it will be possible...

???

I really find it very disturbing that a number of concurrent single-row inserts can cause deadlock. Maybe someone else can explain why this is happening.

To fix the problem I think...