Viewing 15 posts - 15,451 through 15,465 (of 22,221 total)
It will rebuild the indexes, but it might not be the most optimal method, but I only say that because, depending on the table, some tables might be better off...
"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
April 20, 2010 at 4:39 pm
greggoble2 (4/20/2010)
I just installed Visual Studio 2010 and it has compare functionality built in. It is pretty nice.
It is decent and functional. I don't think it quite has all...
"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
April 20, 2010 at 11:11 am
CirquedeSQLeil (4/20/2010)
Grant Fritchey (4/20/2010)
...and I'll give you as big a share of the royalties as I getAnd based on previous comments - we know that ain't very much at all.:-D
Shhhhhhh!...
"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
April 20, 2010 at 9:02 am
CirquedeSQLeil (4/20/2010)
WayneS (4/20/2010)
Roy Ernest (4/20/2010)
... I am always learning here...
And that is why I help out... I end up learning more, and it has the benefit of enforcing 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
April 20, 2010 at 8:54 am
My statement "dubious origin" was probably badly phrased. I think "dubioius benefit" would be more accurate.
But I would still be curious about the origin of some of the statements.
"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
April 20, 2010 at 7:39 am
hrushiatre (4/20/2010)
If you have ever performed a SELECT COUNT(*) on a very large table, you know how long it can take.
For example, when 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
April 20, 2010 at 7:03 am
There are options for the compare, such as "Ignore white space," that you may have unchecked (or checked, depending). I'd go there to see what the settings are.
"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
April 20, 2010 at 6:41 am
It really depends on how you define "affect performance." The fact of the matter is, you're using server resources for tracking errors, possibly at the time when server resources are...
"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
April 20, 2010 at 6:40 am
Like Paul says, huge topic. The simple answers are frequently enough wrong, but still a good starting point.
Look for scans, index or table, these are frequently, but not always, an...
"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
April 20, 2010 at 6:33 am
I had no idea this little forum existed.
You're welcome. I'm glad the book was at all useful.
"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
April 20, 2010 at 6:29 am
A view, unless you're talking about a materialized view, will not help performance in the situation you describe. You need to focus on the queries and what they're doing 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
April 20, 2010 at 6:27 am
The way to tell which parts of the procedure are taking more time is to look at the execution plan. You can run the query yourself through a SQL window...
"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
April 20, 2010 at 6:24 am
arup_kc (4/20/2010)
Gianluca Sartori (4/20/2010)
Some things that come to my mind:1) Badly coded triggers
2) Too many indexes
3) ... any possible reason. The question is too generic to give a good answer.
Hi,...
"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
April 20, 2010 at 6:20 am
Paul White NZ (4/20/2010)
Grant Fritchey (4/20/2010)
But, you don't simply have an ID column and apply a cluster and a noncluster to it, right?
That is exactly what I do 😉
Heh. ...
"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
April 20, 2010 at 6:10 am
Roust_m (4/19/2010)
Grant Fritchey (4/19/2010)
It's going to vary from situation to situation, but the potential for it to have very large impact and take tempdb offline for a considerable length of...
"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
April 20, 2010 at 5:54 am
Viewing 15 posts - 15,451 through 15,465 (of 22,221 total)