Viewing 15 posts - 15,736 through 15,750 (of 22,211 total)
Closed circle then, because I'm reading this stuff to try to understand what I might be seeing in the future.
March 11, 2010 at 9:23 am
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.
March 11, 2010 at 7:47 am
Alberto.Omini (3/11/2010)
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...
March 11, 2010 at 7:37 am
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...
March 11, 2010 at 7:33 am
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.
March 11, 2010 at 7:30 am
Joy Smith San (3/11/2010)
[/Quote]
I had asked this question before also...
Inorder to use OPENQUERY, Do we need to make the linked server using...
March 11, 2010 at 7:13 am
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...
March 11, 2010 at 6:43 am
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
\/
March 11, 2010 at 6:37 am
200 million queries... that's a poster child for the horrors of ORM. Yikes. Best of luck with your issues.
March 11, 2010 at 5:31 am
Paul White (3/10/2010)
GilaMonster (3/10/2010)
Grant Fritchey (3/8/2010)
An unique index and a unique constraint are the same thing (in fact, creating a unique constraint creates a unique index).
Except for 2 points
Unique index...
March 10, 2010 at 6:01 am
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?...
March 9, 2010 at 8:21 am
Lynn Pettis (3/8/2010)
WAY TO GO...
March 8, 2010 at 8:51 pm
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
#34 in Boston went well over 300 (approximately 325) and it was my understanding that we were one of the...
March 8, 2010 at 12:00 pm
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...
March 8, 2010 at 11:05 am
I thought MCP was Main Coolant Pump.
March 8, 2010 at 9:24 am
Viewing 15 posts - 15,736 through 15,750 (of 22,211 total)