Viewing 15 posts - 15,106 through 15,120 (of 22,219 total)
It's hard to tell from that, but I'd start in the usual places. Check the service in the Configuration manager and be sure that it's set to a good login....
"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 6, 2010 at 7:36 am
mckinnj1 (5/6/2010)
homebrew01 (5/5/2010)
The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try harder.
Wow....
"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 6, 2010 at 7:34 am
GilaMonster (5/6/2010)
GilaMonster (5/5/2010)
"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 6, 2010 at 7:32 am
mike.renwick-894639 (5/6/2010)
"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 6, 2010 at 7:31 am
Robert Frasca (5/6/2010)
Grant Fritchey (5/5/2010)
Robert Frasca (5/5/2010)
"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 6, 2010 at 7:29 am
jcrawf02 (5/6/2010)
This made me laugh. Check out Wesley's avatar in this thread
That's a good one. It's the way I feel when reading a lot of the questions too.
"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 6, 2010 at 7:15 am
GilaMonster (5/6/2010)
Grant Fritchey (5/6/2010)
Gianluca Sartori (5/6/2010)
Dave Ballantyne (5/6/2010)
Anyone fancy mind-dumping there entire sql knowledge into a few threads :rolleyes:http://www.sqlservercentral.com/Forums/Topic916801-1292-1.aspx
http://www.sqlservercentral.com/Forums/Topic916751-1292-1.aspx
I could try to attach my whole SQL knowledge to that thread,...
"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 6, 2010 at 6:49 am
I'm with Phil on this one. It was a good read and an interesting solution, but way more difficult than needed since SMO can do so much of the work.
That...
"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 6, 2010 at 6:41 am
Excellent question and, holy cow, I got it right!
"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 6, 2010 at 6:34 am
It depends on where you want to go. I'd suggest either looking at more systems work, getting into the hardware & os configurations in a major way, or development, learning...
"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 6, 2010 at 6:29 am
In addition to the links provided and the information there, just remember, setting MAXDOP is all well and good, but you need to worry more about the parallelism threshold. 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 6, 2010 at 6:25 am
Gianluca Sartori (5/6/2010)
Dave Ballantyne (5/6/2010)
Anyone fancy mind-dumping there entire sql knowledge into a few threads :rolleyes:http://www.sqlservercentral.com/Forums/Topic916801-1292-1.aspx
http://www.sqlservercentral.com/Forums/Topic916751-1292-1.aspx
I could try to attach my whole SQL knowledge to that thread, it shouldn't exceed...
"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 6, 2010 at 6:22 am
I agree.
A company is not an individual and an individual is not a company. Further, you wouldn't want a one-to-one relationship between the two. I work for a company with...
"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 6, 2010 at 6:20 am
I'm not familiar with the BMC product you're working with, but what's going on is that you have a blocking threshold set within the product. When that threshold is exceeded,...
"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 6, 2010 at 6:16 am
No, you need to go to TSQL to fix them, usually one at a time.
"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 6, 2010 at 6:12 am
Viewing 15 posts - 15,106 through 15,120 (of 22,219 total)