Viewing 15 posts - 18,391 through 18,405 (of 22,226 total)
Ken Gaul (2/13/2009)
That's where I got the bad plan in the first place I'm afraid. I was a little surprised to see it was an estimated plan though.
Really? An estimated...
"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 7:12 am
Welcome to blogging. I've heard rumors that syndication may be starting up around here. Be sure to volunteer when they get it going.
"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 7:04 am
How about querying sys.dm_exec_query_plans and pull it out of there? That would be the best way to go for something of this nature.
"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 6:31 am
That's not a standard error message that I'm aware of. What's the context in which you're recieving it?
"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 6:10 am
The main problem is to join two tables from two servers, you have to move the entire contents of one of the tables to the other server. So as you...
"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 6:07 am
It's hard to not to say something stupid without the execution plan (and all too easy then). The one thing that bothers me about the code so far is this,...
"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 6:00 am
You can, but why not use the CTE?
"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:53 am
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
Viewing 15 posts - 18,391 through 18,405 (of 22,226 total)