Like Gail said, they can be problematic. It's the multi-statement table valued functions that will really chew on you. The single statement ones generally will create a good execution plan...

You left out triggers...

Good editorial. I agree with it. I also take, a very slight, exception to it. The problems that people who post here every day see are not...

GSquared (8/11/2008)

---

Take it easy on my relatives there! Just because a few branches of the family tree curl back on themselves...

Soccer officiating sounds worse...

Sorry I haven't been taking part in the discussion. Rhode Island celebrates VJ Day so I had the day off... Whatever.

Adding in reporting or views would be a good idea,...

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