Assuming the query plans are the same, I'd tend to go with the second one as well.

Are you working from the execution plan? You need to understand how SQL Server is accessing the data. The execution plan will tell you what's going on. It's less accurate,...

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...

timothyawiseman (8/8/2008)

---

Until this week, I did absolutely nothing. Then I got talked into preparing for a Marathon, so I started jogging each morning.

Several people have mentioned martial arts, which...

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...

An execution plan would sure make a difference.

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...

GilaMonster (8/8/2008)

---

Steve Jones - Editor (8/8/2008)

---

I'd have thought that Gail and Grant would just sit a bow in the corner of their cube and eliminate all complaints in person. Hard...

Oh yeah, good one....

Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by...

Christopher Stobbs (8/8/2008)

---

Grant,

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...

GilaMonster (8/8/2008)

---

majorbloodnock (8/8/2008)

---

GilaMonster (8/8/2008)

---

There's an interesting correlation between IT (and the wider science field) and martial arts....

Someguy (8/8/2008)

---

I'm surprised how many of the readers here are into martial arts. I hope I don't run into any in a dark alley after my next tech conference. :w00t:

I...

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...

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...