Viewing 15 posts - 19,786 through 19,800 (of 22,226 total)
Yeah, that's pretty common. We have a Microsoft consultant who comes in on site to help us with OM issues. I showed him what I was doing and he started...
"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
August 8, 2008 at 10:35 am
timothyawiseman (8/8/2008)
Several people have mentioned martial arts, which...
"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
August 8, 2008 at 9:12 am
I do agree. Most of what you're doing in 2005 and most of the way you do it, should remain the same. The one area that I think might bite...
"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
August 8, 2008 at 8:59 am
An execution plan would sure make a difference.
"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
August 8, 2008 at 8:57 am
163 rows can, depending on the table, fit on one or two pages. That's just not going to be an issue if it goes to three or four. You'll want...
"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
August 8, 2008 at 8:52 am
GilaMonster (8/8/2008)
Steve Jones - Editor (8/8/2008)
"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
August 8, 2008 at 8:46 am
GilaMonster (8/8/2008)
Grant Fritchey (8/8/2008)
[Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by deletes.
Shrinking the database or the data file.
Oh yeah, good one....
"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
August 8, 2008 at 8:25 am
Christopher Stobbs (8/8/2008)
THis pretty exciting stuff 🙂Thanks for all the help everyone.
Whats cause index fragmentation?
Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by...
"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
August 8, 2008 at 8:17 am
Christopher Stobbs (8/8/2008)
Do you have any tips/advice on scripts that you mentioned above, that check indexes and fragmentation etc?
and how often you do this kind of thing on your system.
I'm...
"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
August 8, 2008 at 8:15 am
GilaMonster (8/8/2008)
majorbloodnock (8/8/2008)
GilaMonster (8/8/2008)
Someguy (8/8/2008)
I'm surprised how many of the readers here are into martial arts.
There's an interesting correlation between IT (and the wider science field) and martial arts....
"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
August 8, 2008 at 8:11 am
Someguy (8/8/2008)
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
August 8, 2008 at 8:08 am
If I were you, I'd do some serious testing. I suspect the cost of maintaining statistics in most systems, for most databases, is a lot lower than the cost 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
August 8, 2008 at 6:22 am
I take martial arts training twice a week and I help teach it once a week. I spend a couple of hours most weekends splitting wood. In between times, 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
August 8, 2008 at 6:16 am
Thanks. I'm glad it was at all helpful. Keep an eye out for Thomas LaRock articles too. I know he's got a new one coming becuase he let me review...
"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
August 8, 2008 at 5:56 am
Jeremy Brown (8/7/2008)
Hey Grant, do you have a general value you apply or do you use some kind of formula based on counters? Just curious.
Although, now that I think...
"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
August 7, 2008 at 1:21 pm
Viewing 15 posts - 19,786 through 19,800 (of 22,226 total)