Third vote. You're on the money the other guys need to go back & hit the books.

You say the data is "huge" but what does that mean in real terms? It sounds like you may have tuning opportunities in the SSIS data load.

Regardless, one way around...

Sumanta-1056020 (4/21/2010)

---

Hi Adi,

We got microsoft recommendation like this..

An index that is more than 5 percent or less than 30 percent fragmented should be reorganized. In addition, an index that is...

I'd start with the Books Online. You're listing a large swath of different performance metrics, so there's not going to be a single source for this information except for a...

Whisper9999 (4/20/2010)

---

Grant Fritchey (4/20/2010)

---

It will rebuild the indexes, but it might not be the most optimal method, but I only say that because, depending on the table, some tables might...

It will rebuild the indexes, but it might not be the most optimal method, but I only say that because, depending on the table, some tables might be better off...

It is decent and functional. I don't think it quite has all...

Shhhhhhh!...

CirquedeSQLeil (4/20/2010)

---

WayneS (4/20/2010)

---

And that is why I help out... I end up learning more, and it has the benefit of enforcing what...

My statement "dubious origin" was probably badly phrased. I think "dubioius benefit" would be more accurate.

But I would still be curious about the origin of some of the statements.

hrushiatre (4/20/2010)

---

Consider below some of the important points

If you have ever performed a SELECT COUNT(*) on a very large table, you know how long it can take.

For example, when I...

There are options for the compare, such as "Ignore white space," that you may have unchecked (or checked, depending). I'd go there to see what the settings are.

It really depends on how you define "affect performance." The fact of the matter is, you're using server resources for tracking errors, possibly at the time when server resources are...

Like Paul says, huge topic. The simple answers are frequently enough wrong, but still a good starting point.

Look for scans, index or table, these are frequently, but not always, an...

I had no idea this little forum existed.

You're welcome. I'm glad the book was at all useful.