Viewing 15 posts - 17,341 through 17,355 (of 22,226 total)
Grant Fritchey (5/31/2009)
Roy Ernest (5/29/2009)
I got it from...
"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
June 1, 2009 at 7:28 am
And when you post the execution plan, please make it the actual execution plan. Thanks.
"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
June 1, 2009 at 6:41 am
Let me rephrase the question to see if I understand.
Are you asking is it possible to put data into the foreign key that is not contained in the primary key...
"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
June 1, 2009 at 6:37 am
WayneS (5/30/2009)
Side note question here... how appropriate is it to mention being an Eagle Scout on your DBA resume?
It would increase the chances that I hire someone, without a doubt.
"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
May 31, 2009 at 9:34 am
Roy Ernest (5/29/2009)
I got it from SSC itself[/url]....
"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
May 31, 2009 at 9:29 am
Enterprise or Express or Developer, those are all database servers. It sounds like you want the client tools. That's Management Studio and can be installed seperately from any 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
May 29, 2009 at 6:43 am
So the estimated & actual rows are the same? Actual number of executions, rebinds, rewinds... There is more data to it than just the operators. Sorry, just trying to understand...
"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
May 29, 2009 at 6:34 am
GilaMonster (5/29/2009)
Lurking a fair bit here at the moment, cause there's little better to do. Hence I'm catching this kinda stuff early.
Got no major projects that I'm busy with, just...
"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
May 29, 2009 at 6:29 am
I do hate doing this, but those are both estimated plans. Can you post the actual plans?
As to why you're getting a seek or scan, if you look at 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
May 29, 2009 at 5:33 am
David Burrows (5/29/2009)
Grant Fritchey (5/28/2009)
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German...
"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
May 29, 2009 at 5:24 am
Are there other columns in the table? Do you know what a foreign key (FK) is? Maybe this is a FK to another table where you can look up what...
"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
May 28, 2009 at 5:07 pm
You just schedule it to run every x number of minutes/hours, however often you or the the business have decided it needs to be run, and start it at 11:15...
"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
May 28, 2009 at 12:24 pm
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German Shephard, Maximus. He's 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
May 28, 2009 at 12:20 pm
Don't worry Roy, I've got your back. I can't stand cats either.
"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
May 28, 2009 at 11:47 am
I suspect you're seeing parameter sniffing (do a search on that term for possible solutions). I'm saying this based on the fact that you see this: '[woon_ptc]=[@P1]' in the first...
"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
May 28, 2009 at 10:36 am
Viewing 15 posts - 17,341 through 17,355 (of 22,226 total)