Viewing 15 posts - 11,551 through 11,565 (of 22,224 total)
durai nagarajan (12/7/2011)
hope both gives better performanace than cursors.
It depends on what you're doing with 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
December 7, 2011 at 5:04 am
Another option to pursue, and a good plan for your long term skill set development, is to use Extended Events to capture all user activity. It works a lot like...
"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 7, 2011 at 5:03 am
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! ...
"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 6, 2011 at 3:36 pm
GilaMonster (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I...
"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 6, 2011 at 1:29 pm
I'd say minimum, all projects go through Dev, Staging & Prod. Formal QA might be a luxury, but validating deployments sure isn't.
I listed a number of possible environments and 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
December 6, 2011 at 11:40 am
Ninja's_RGR'us (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I...
"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 6, 2011 at 10:50 am
Krasavita (12/6/2011)
If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and...
"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 6, 2011 at 10:35 am
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I know why neither...
"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 6, 2011 at 10:33 am
LutzM (12/6/2011)
Changing subject: Does anyone know one of the DBAinSpace finalists?There's no name I recognize as one of the Threadizens....
I'm friends with Tim Ford. He's an MVP. He runs SQL...
"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 6, 2011 at 10:31 am
Oh, sure. I'd suggest taking a look at SQL Monitor[/url] from Red Gate Software then. .
"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 6, 2011 at 10:26 am
Krasavita (12/6/2011)
ok, I am in the process of installing,so how can I Leave 2GB for the OS(where do I check for this?)Thank you
After you do the install, you change 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
December 6, 2011 at 9:07 am
Krasavita (12/6/2011)
This is I always can't get it right,how much set max memory?Thank you
It depends on the system, but, in general, you should retain 1-2gb for the OS, so set...
"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 6, 2011 at 7:05 am
It sure sounds like it's statistics related. When you rebuild the stats, are you using sp_updatestats or are you running UPDATE STATISTICS? If the former, try using the latter and...
"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 6, 2011 at 6:57 am
When you say performance tuning, what do you mean? Do you mean monitoring and alerting or something that will literally suggest or make changes to your system and/or queries?
"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 6, 2011 at 6:50 am
I really don't think this is a good solution for a production system, at all, but if you want very fast restores, you should take a look at something like...
"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 6, 2011 at 6:32 am
Viewing 15 posts - 11,551 through 11,565 (of 22,224 total)