Viewing 15 posts - 18,076 through 18,090 (of 22,226 total)
Yes, the best way to determine what needs indexing is to use Profiler, or TSQL, to create a server side trace to capture data over time. You can then run...
"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
March 7, 2009 at 4:49 am
If the OUT process changes a lot of the data, especially if it does a lot of deletes, you could be seeing index fragmentation affecting the next process. Hard 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
March 7, 2009 at 4:45 am
DavidB (3/6/2009)
My guess is that the FTI will perform better, and I believe you would limit those reads a bit as well. 🙂
Quite likely, but I'd test it very thoroughly....
"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
March 6, 2009 at 5:06 pm
Jeff Moden (3/6/2009)
Grant Fritchey (3/6/2009)
At this point, I'm calling this a troll.http://www.sqlservercentral.com/Forums/FindPost670625.aspx
Remember, don't feed the trolls.
Heh... what? They don't like pork chops? 😉
I told him to stop trolling 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
March 6, 2009 at 4:57 pm
This will lead to table or index scans
and ProEmail like '%@%'
"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
March 6, 2009 at 1:35 pm
At this point, I'm calling this a troll.
http://www.sqlservercentral.com/Forums/FindPost670625.aspx
Remember, don't feed the trolls.
"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
March 6, 2009 at 1:33 pm
chrisau168 (3/6/2009)
wanted to confirm some basic concepts about indexes.
my understanding of clustered index and nonclustered index is like this.
if I have a clustered index on column "a" and I have...
"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
March 6, 2009 at 12:58 pm
I don't like maintenance plans because they don't offer enough control. Instead, we generally write out our maintanenance plans and schedule. The creation is manual, but the execution is automated.
BTW,...
"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
March 6, 2009 at 11:34 am
Lynn Pettis (3/6/2009)
Mangal9i (3/6/2009)
Talking about execution plan, run both my query and your query and see cost of the query.
Its 1% VS 99%.
I was not aware...
"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
March 6, 2009 at 11:29 am
RBarryYoung (3/6/2009)
First, there is no such thing as an "MSDN MVP" it'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
March 6, 2009 at 11:27 am
GSquared (3/6/2009)
jcrawf02 (3/6/2009)
Chris Morris (3/6/2009)
In any case, the best or, more rarely, the correct answer here is usually blindingly obvious.
To you, Chris, or to someone who knows that they're doing....
"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
March 6, 2009 at 11:25 am
Putts (3/6/2009)
I would agree with your sentiment that there must be something awry with...
"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
March 6, 2009 at 9:45 am
rudy komacsar (3/6/2009)
"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
March 6, 2009 at 9:30 am
Putts (3/5/2009)
Was able to get acceptable times on the original query I was working with but now I'm working on a different one and am running into the same problem.
Following...
"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
March 6, 2009 at 7:47 am
groffg (3/6/2009)
"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
March 6, 2009 at 7:04 am
Viewing 15 posts - 18,076 through 18,090 (of 22,226 total)