Viewing 15 posts - 12,091 through 12,105 (of 22,224 total)
I wouldn't expect it to behave like that, no. Yeah, I'd expect a slow-down as there absolutely would be contention on the resources, but not something at that magnitude. 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
August 11, 2011 at 11:32 am
Well done Brandie. The only real author I know and we still haven't met.
"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
August 11, 2011 at 11:28 am
I'd like to recommend you get a copy of this book. And then a copy of this one. They cover what you're asking.
"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
August 11, 2011 at 6:13 am
Yeah, set up a role with all appropriate permissions and then add the users to that. Then you don't have to transfer rights from one user to the next. That's...
"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
August 11, 2011 at 6:12 am
While I'd prefer you run out & buy 50 or 60 copies of Red Gate SQL Monitor[/url] (my employer), you might be able to get a quick & easy report...
"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
August 11, 2011 at 6:08 am
something that's getting worse over time like that, it might be statistics that need to be updated. Try running the UPDATE STATISTICS command on the tables that are accessed by...
"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
August 11, 2011 at 5:43 am
Another vote for ERStudio from Embarcadero. Excellent piece of software.
"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
August 11, 2011 at 5:39 am
Koen Verbeeck (8/11/2011)
Grant Fritchey (8/11/2011)
Brandie Tarvin (8/11/2011)
Is it just me, are am I being particularly unhelpful this morning?http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx
No. And that one guy, "tell me how to design a database." Oh...
"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
August 11, 2011 at 5:36 am
Brandie Tarvin (8/11/2011)
Is it just me, are am I being particularly unhelpful this morning?http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx
No. And that one guy, "tell me how to design a database." Oh please. Seriously?
"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
August 11, 2011 at 5:29 am
There are scads of books on the topic. You're not going to be able to learn how to do it from a post on a forum.
"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
August 11, 2011 at 5:29 am
If you notice, that's a link. If you click it, it should give you more information.
"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
August 11, 2011 at 5:17 am
Stuart Davies (8/11/2011)
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was...
"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
August 11, 2011 at 5:12 am
Matt Miller (#4) (8/10/2011)
Grant Fritchey (8/10/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
August 10, 2011 at 1:26 pm
Ninja's_RGR'us (8/10/2011)
Grant Fritchey (8/10/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
August 10, 2011 at 8:30 am
I agree. The DTA is a very dangerous tool and it's suggestions can be problematic, in the extreme. After reading Gail's articles, get a copy of my book. It'll take...
"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
August 10, 2011 at 8:22 am
Viewing 15 posts - 12,091 through 12,105 (of 22,224 total)