Viewing 15 posts - 15,466 through 15,480 (of 22,227 total)
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
RBarryYoung (4/19/2010)
Kit G (4/19/2010)
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 19, 2010 at 7:18 pm
Lynn Pettis (4/19/2010)
Grant Fritchey (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:13 pm
The default trace doesn't capture DML. I learned that one the hard way.
"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 1:20 pm
I owned two different Pacers. One worked great unless it rained. Then, if you splashed through a puddle more than 1/2 deep, it would immediately stall. Great fun, especially on...
"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 1:07 pm
You would need to pick up a third party log explorer tool. There's no way to do this with native SQL Server tools.
"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 12:44 pm
Viewing 15 posts - 15,466 through 15,480 (of 22,227 total)