Viewing 15 posts - 18,391 through 18,405 (of 22,219 total)
Entity Framework assumes a data model in the database and works with it to map between the data model and your object model. nHibernate can work that way, but our...
"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
February 13, 2009 at 5:47 am
Roy Ernest (2/12/2009)
"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
February 12, 2009 at 12:29 pm
Another vote for execution plans.
Check this article, [/url]and this one [/url]if you're new to them.
"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
February 12, 2009 at 11:44 am
If performance has been degrading over time, in addition to doing what Jack suggests, you should update the statistics, probably with a full scan, and set up a schedule to...
"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
February 12, 2009 at 11:41 am
GilaMonster (2/12/2009)
http://www.sqlservercentral.com/Forums/FindPost655667.aspx
I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?
Gees, it took me months of reading to decide on an appropriate...
"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
February 12, 2009 at 11:18 am
Bob Hovious (2/12/2009)
I tried to help him out with that one Grant. Maybe because it's early and I'm well rested. I read him as saying "I would...
"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
February 12, 2009 at 7:42 am
I talk to myself all the time, to the horror of all my co-workers.
OK. You could try a query hint in this case, the OPTIMIZE FOR hint might help out....
"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
February 12, 2009 at 6:57 am
But the key word and tricky phrase in that sentence was "during planned down time." I hear a question like this and I can sense my hackles going up.
"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
February 12, 2009 at 6:49 am
Roy Ernest (2/12/2009)
I like to help, but I am very very bad at explaining....
"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
February 12, 2009 at 6:22 am
You could post the execution plan & query to see if anyone can spot something. I'd do that in a seperate post though so you get more eyeballs.
"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
February 12, 2009 at 6:19 am
Ah. OK. Good answer. 😀
"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
February 12, 2009 at 6:18 am
Yeah, I'm going to pile on with Lowell here. Running a check every 30 seconds and updating a status does what exactly that simply writing the same check into a...
"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
February 12, 2009 at 6:15 am
About the same as the way I feel about the "tax cuts" going to people who paid no taxes.
"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
February 12, 2009 at 6:12 am
I don't have all the answers to your question, but I can advise you to look in a slightly different direction. LINQ is being swallowed up the Entity Framework. That's...
"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
February 12, 2009 at 6:11 am
I've been trying to stay away from this thread, but here's one:
http://www.sqlservercentral.com/Forums/FindPost655416.aspx
"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
February 12, 2009 at 6:07 am
Viewing 15 posts - 18,391 through 18,405 (of 22,219 total)