Viewing 15 posts - 12,091 through 12,105 (of 22,219 total)
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
sal-295209 (8/10/2011)
can anyone give me some guidelines (tips and tricks) on fine tuning sql server 2008 r2 database ? my email is sali2610@hotmail.comThank You
Take a look at my signature line....
"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:20 am
No real way around this. The whole idea of hints to take away control from the optimizer. One of the many reasons I'm not in favor of using hints.
"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:08 am
That's a huge topic. I'd like to suggest you take a look at a book, SQL Server Team-Based Development. It's free (unless you want to get a printed copy). 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
August 10, 2011 at 8:07 am
With only scripts, there's little you can do in terms of monitoring. Monitoring, as a concept, implies gathering data continually in order to respond to the information gathered or 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
August 10, 2011 at 7:18 am
In general it's either the query, the statistics or the indexes. Take a look at the predicate values in the properties of the scan. It'll tell you what it's searching...
"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 7:13 am
Viewing 15 posts - 12,091 through 12,105 (of 22,219 total)