Viewing 15 posts - 11,491 through 11,505 (of 22,224 total)
You could try print statements in the script and proc and then capture the output from the job to see what you get 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
January 3, 2012 at 8:51 am
Think about it like this, you don't need three columns, you have three potential pieces of information for a unique relationship between a student and a course. That might help...
"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
January 3, 2012 at 7:47 am
chandan_jha18 (1/3/2012)
Jeff Moden (1/3/2012)
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Jeff Moden (1/3/2012)
"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
January 3, 2012 at 7:34 am
You've got a query that is looping reads on a table waiting for inserts... You might just be blocking one process or the other. I'm not sure that's the approach...
"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
January 3, 2012 at 7:31 am
I suspect there are a bunch of tuning opportunities in the query, including the possibility of adding indexes. Knowing nothing else about the situation the one thing I'd look at...
"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
January 3, 2012 at 7:28 am
I'm not so sure I'd be too quick to dismiss the issue as SQL Server. It sounds like it could be bad parameter sniffing. Especially since clearing the procedure cache...
"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
January 3, 2012 at 7:24 am
You may think there's enough space, but SCCM disagrees, although it may be a default message meaning "something went wrong." Double check the server you're running it on to see...
"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
January 3, 2012 at 7:19 am
Stefan Krzywicki (12/29/2011)
GilaMonster (12/29/2011)
Stefan Krzywicki (12/29/2011)
I don't have room on my machine either.Two words: External harddrive.
Seriously, I've had to do that once or twice.
I can't even get them to buy...
"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
December 29, 2011 at 10:04 am
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
"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
December 29, 2011 at 9:26 am
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
"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
December 29, 2011 at 9:24 am
Jeff Moden (12/26/2011)
I have a serious question for my fellow Threadizens...
Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts,...
"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
December 27, 2011 at 8:23 am
Ninja's_RGR'us (12/23/2011)
Grant Fritchey (12/23/2011)
GilaMonster (12/23/2011)
Grant Fritchey (12/23/2011)
I've been on vaca this week and I'll be on it next week.
Nice. I'm supposed to be working today, but meh... I'll keep til...
"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
December 23, 2011 at 5:12 am
GilaMonster (12/23/2011)
Grant Fritchey (12/23/2011)
I've been on vaca this week and I'll be on it next week.
Nice. I'm supposed to be working today, but meh... I'll keep til next week, or...
"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
December 23, 2011 at 5:02 am
GilaMonster (12/23/2011)
Grant Fritchey (12/23/2011)
Merry Christmas, Happy Yule, Happy Hannukah, Happy New Year, Joyous Kwanzaa, Profitable Festivus, Yippee Kai Yay Mother ..., and all the rest!
Hey, long time no see (here)
Same...
"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
December 23, 2011 at 4:44 am
Merry Christmas, Happy Yule, Happy Hannukah, Happy New Year, Joyous Kwanzaa, Profitable Festivus, Yippee Kai Yay Mother ..., and all the rest!
"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
December 23, 2011 at 4:14 am
Viewing 15 posts - 11,491 through 11,505 (of 22,224 total)