Thanks.

I tried to delete all mail items before I posted the question but almost 24 hours later sp_who still shows a DELETE is in suspended status. When I query...

Thanks.

Another question: when I have one SQL server license on a 4 CPU server, is it all I need as long as I have enough SQL CAL to...

MANU (11/14/2008)

---

What is actually slow?

If the application is responding slowly then have you tried running the queries ran by application manually under query analyzer? What is the Index structure and...

Glen (11/14/2008)

---

Why did you concentrate on the SQL server parameters only?

What about your network traffic? Do you have a single network card on this box? What is the network...

WOW!!!!!

That is exactly what I am looking for. Thanks a million.

Table definitions is in the sample data. I am just looking for a query to produce a result that look like the result when you run the second query....

Thanks!

I also found this qurey worked for me:

select a.AgentID, a.AgentType from

(select AgentID, row_number() over (partition by AgentID order by TransDate desc) as row, TransDate, AgentType from #a) a

where...

Thanks for quick answer.

worked like a charm!

thx.

That was an old post. btw we don't use NOLOCK in our queries.

Thanks guys for keeping this thread up. I've had this error for almost 2 years on a SQL 2000 SP4 server and can't see any fix to make it...

thank guys for the replies. I knew where I had to go for help.

I used an article at sql-server-performance.com to do manual log shipping b/w 2 SQL Std 2000 server. Worked perfectly. Search for log shipping when you go to this...

• disable all constraints on tables depending on the destination table.
• delete the destination table.
• copy SQL object: keep existing table, copy data, append data instead of replace.
• re-enable all constraints on tables depending...

Thank you.  We have oversea developers working on a separate project that when they plugged it into our existing dev system the SQL server is brought down to its knees with...