Viewing 15 posts - 7,441 through 7,455 (of 22,226 total)
That's the only place I'm aware of to make those kinds of changes.
"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
September 25, 2014 at 7:17 am
Wison (9/25/2014)
you can use profiler on third server to Monitor the sql statements which cause the CPU high.or
get the sql statements from the DMV.
Use trace or extended events 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
September 25, 2014 at 6:43 am
You can have a section in your resume called Certifications and list it there. As to writing the manual, that should be part of the description of that job.
"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
September 25, 2014 at 6:39 am
Try going to the Options screen, Environment, Keyboard. Then you can try doing a reset on the keyboard scheme you're on. That ought to do 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
September 25, 2014 at 6:33 am
It really depends on how the optimizer is resolving those queries. It's also dependent on how you're writing the queries. AND, it's dependent on the indexes you have on 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
September 24, 2014 at 12:00 pm
works extremely well, even with users connected.
"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
September 24, 2014 at 11:53 am
Jeff Moden (9/24/2014)
Chowdary's (9/24/2014)
I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go...
"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
September 24, 2014 at 8:08 am
Chowdary's (9/24/2014)
I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So...
"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
September 24, 2014 at 8:06 am
Some filtering then, but, assuming that's a CHAR(1) field, not much filtering at all, so you're still going to be looking at scans and few options for the optimizer 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
September 24, 2014 at 8:05 am
There doesn't seem to be any tuning opportunities in the code itself. You're retrieving all the data from two tables in a UNION ALL with no filtering. The optimizer is...
"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
September 24, 2014 at 5:14 am
Personally, the best ones are from Red Gate Software[/url]. They have tools for both monitoring and backups. But then, I am prejudiced since I work for them.
You should just do...
"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
September 24, 2014 at 5:07 am
I experimented with doing backups simultaneously. It's possible with PowerShell to set up a threaded process to fire off all the backups at the same time. The results were pretty...
"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
September 24, 2014 at 4:53 am
Having just going through the nomcom process, I thought it seemed pretty fair. There's an assumption of knowledge about the inner workings of the board that maybe shouldn't be there....
"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
September 20, 2014 at 6:56 am
TomThomson (9/18/2014)
Grant Fritchey (9/17/2014)
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.
Were it not for 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
September 19, 2014 at 7:03 am
Roy Ernest (9/18/2014)
"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
September 18, 2014 at 6:38 am
Viewing 15 posts - 7,441 through 7,455 (of 22,226 total)