What sleeping condition?

They're not bad-disk related. They're slow disk related. By themselves, these errors don't indicate corruption. They indicate that the IO system is overloaded or very poorly performing.

Jpotucek (4/28/2008)

---

SQL Server has encountered 37 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [e:\Microsoft SQL Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file...

Can you post the schema of the tables and their indexes please?

Without that, we're just guessing.

Proper indexes and up to date statistics. Compiler hints are to be avoided wherever possible.

Can you post the schema of the tables, the indexes defined and the aprox row counts...

Well, obviously not as written. That's just the framework of the...

Last time I saw this it was due to really bad network connectivity between the publisher and the distributor.

Check your network, check the settings on the cards, check the available...

Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums

No replies to this thread please. Direct replies to the following thread...

Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums

No replies to this thread please. Direct replies to the following thread...

Perhaps something like this?

SELECT * , ROW_NUMBER ...

FROM

(SELECT empid1,name1,joindate from emp where empid2=3

union

select empid2,name2,joindate from emp where id1=3) sub

Can you please post the queries that are taking longer, as well as the delete statement.

Are you running SQL 2005? If so, please save the execution plan as a .sqlplan...

Great. There's just one thing I wanna know...

How fast was it?

Why don't you just put a unique constraint on the emp_id column? No need for a trigger at all.

Um, maybe trash the cursor and do it as a set-based update. Shouldn't take more than an hour...

Untested, because I don't have schema, sample data or expected output. Should be...

What part don't you understand?

When SQL uses a variable in a where clause it uses the contents of the variable as a literal value. Not as a reference to a...

You need to add a linked server before you can use 4-part naming to refer to a remote machine.

If you're sysadmin, you shoul be able to do that yourself. Go...