Viewing 15 posts - 17,581 through 17,595 (of 22,226 total)
How much data is in the table, specifically how many pages?
For very small tables, less than 10 pages, you might not see any change in fragmentation, even after a rebuild...
"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 29, 2009 at 5:02 am
Yeah, that sounds familiar. I'd suggest recompiling after the data load and avoid using query hints. Since you know it's going to happen, take care of it that way. Also,...
"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 29, 2009 at 4:58 am
Without details it's not possible to give you specific advice. In general, make sure you have a clustered index on the table. Make it as narrow as you can, but...
"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 29, 2009 at 4:52 am
Track down a copy of Brad McGehee's "How To Be An Exceptional DBA." It's a great read. For a fantastic introduction to the concept of being a DBA, I recommend...
"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 29, 2009 at 4:43 am
You need to use a server-side trace. You can build this manually using the T-SQL commands or you can use the SQL Profiler tool to build it for you. This...
"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 29, 2009 at 4:40 am
Thanks for posting the answer. It's always good to know when I got something right.
"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 29, 2009 at 4:25 am
Bruce W Cassidy (4/28/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
April 29, 2009 at 4:14 am
There are several articles on Gail Shaw's blog[/url]. There are several good articles here on SQL Server Central, just search in the window in the upper right. For real depth...
"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 28, 2009 at 1:28 pm
GilaMonster (4/28/2009)
Grant Fritchey (4/28/2009)
Hmmm... Now I am confused.
You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache....
"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 28, 2009 at 1:18 pm
Hmmm... Now I am confused. I remember seeing that in action, but when you run RECONFIGURE WITH OVERRIDE the cache gets cleaned out, so I couldn't have done it playing...
"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 28, 2009 at 12:27 pm
I did it in the execution plan book. Let me look it up...
Damn, found a typo. I'm blaming you becuase I wouldn't have seen it otherwise...
Crap... Evidently I just lied......
"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 28, 2009 at 12:19 pm
Looks like your statistics might be a tad off. The index seek operation that is taking up 86% of the cost shows an estimated 1 row, but is returning 65000....
"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 28, 2009 at 11:42 am
Since SQL Server 2000 is off the main stream support path, how about the fact that if a mandatory security patch comes out that breaks 2000, you can't count 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 28, 2009 at 11:34 am
Can you save the actual execution plan as a .sqlplan file, zip it and attach that? Without all the underlying data it's hard to read an execution plan.
"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 28, 2009 at 11:30 am
I'm sorry, I've never seen that one occur before. On a guess, someone did it. Especially if it's everywhere.
"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 28, 2009 at 11:14 am
Viewing 15 posts - 17,581 through 17,595 (of 22,226 total)