Closed circle then, because I'm reading this stuff to try to understand what I might be seeing in the future.

It sounds like, possibly, the app is holding the transaction open. If you close the window the connection and the wait clears... pretty good indicator.

Alberto.Omini (3/11/2010)

---

Hi people.

I have a problem between Access and Sql2005.

I use a linked table inside temporary access mdb.

Client have sqlexpress insalled (two version : one is 9.0.053 and the other...

Sleeping or running doesn't indicate whether or not a query needs tuning. You need to pick a methodology of monitoring that will inform you of where the problems lie. I...

The wait state suggests that your process is waiting either on traffic on the network or the client software is not taking the results quickly enough.

Joy Smith San (3/11/2010)

---

[Quote] You can do this using the OPENQUERY function.

[/Quote]

I had asked this question before also...

Inorder to use OPENQUERY, Do we need to make the linked server using...

The question isn't whether or not putting more memory on the box will speed up the query. The question is whether or not your query is running slow because of...

Maybe it's getting updated for 2008. 2005 is getting just a tad long in the tooth at this point. I might suggest an alternative

I

I

I

I

\/

200 million queries... that's a poster child for the horrors of ORM. Yikes. Best of luck with your issues.

Paul White (3/10/2010)

---

GilaMonster (3/10/2010)

---

Except for 2 points

Unique index...

Assuming the complexity of the queries is as you've outlined, both will probably work about the same way.

However, are single row inserts the best way to move millions of rows?...

Lynn Pettis (3/8/2010)

---

IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

WAY TO GO...

#34 in Boston went well over 300 (approximately 325) and it was my understanding that we were one of the...

It does cause some overhead, which is why, most of the time, you try to schedule database backups for slower operation times. However, it does not lead to blocking as...

I thought MCP was Main Coolant Pump.