Viewing 15 posts - 15,466 through 15,480 (of 22,232 total)
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
Paul White NZ (4/20/2010)
Roy Ernest (4/15/2010)
I have never heard of anyone recommending to have both clustered and non clustered on the same column. This is the first time.
It's not 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 5:51 am
anthony_merriwether (4/19/2010)
"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:46 am
Roust_m (4/19/2010)
"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 19, 2010 at 7:30 pm
Jeff Moden (4/19/2010)
only4mithunc (4/19/2010)
Unfortunately I didn't check these two things... And as I mentioned, when I dropped and recreated the SP it was fine, so no chance...
"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 19, 2010 at 7:25 pm
Viewing 15 posts - 15,466 through 15,480 (of 22,232 total)