Viewing 15 posts - 15,751 through 15,765 (of 22,226 total)
Closed circle then, because I'm reading this stuff to try to understand what I might be seeing in the future.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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
\/
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2010 at 8:21 am
Lynn Pettis (3/8/2010)
WAY TO GO...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2010 at 11:05 am
I thought MCP was Main Coolant Pump.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2010 at 9:24 am
Viewing 15 posts - 15,751 through 15,765 (of 22,226 total)