Jeff Moden (4/8/2010)

---

A low fill factor...

Nadrek (4/8/2010)

---

What's the Fill Factor on the indexes with the fragmentation issues?

If you're doing updates or inserts throughout the values of the index, I would recommend trying a value lower...

JDixon-385826 (4/7/2010)

---

if you have enough resources and enterprise edition you should be able to do the operation online and only rebuild if you need to. I would start with looking...

Here is what's on the SQLDUMPER_ERRORLOG.log file:

(1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

(1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1908

(1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0

(1158:1718) 04/06/10...

Paul White NZ (4/4/2010)

---

Marios Philippopoulos (4/4/2010)

---

The database code in our system is littered with NOLOCK hints, and we are considering switching to Read Committed Snapshot Isolation (RCSI) in the near...

sneugebauer (11/19/2008)

---

I had same problem, but I got it working by adding two \" inside the quotes of "Excel Connection Manager", that it works. So it looks like this:...

Jeff Moden (3/31/2010)

---

Since you have the Enterprise Edition, I'd consider partitioning the table and the indexes so they can be more easily...

CirquedeSQLeil (3/30/2010)

---

10% fragmentation seems like an awfully low threshold. I've been in environments where we didn't touch it unless it was 50% (1TB plus databases). Then we would...

I'm on SQL 2008 SP1, Enterprise Ed.

Good question; I guess it points to a 2nd strategy, finding out which of these "problem" indexes are...

Thank you for the article.

I have been struggling to figure out what each of the metrics means in the SQL Sentry Performance Advisor dashboard, and I must admit I am...

Toby White (3/26/2010)

---

One further note - for the step type T-SQL the step is actually executed under the context of the owner. You can test this out easily enough by...

Toby White (3/26/2010)

---

It doesn't matter that much because they would be the owner o the job, and could not do anything inside the job for which they do not have...

Problem solved; we had to upgrade SSRS to SQL 2008 SP1; there was a version incompatibility with the other SQL components installed on the user's machine (SP1 was already installed...

Will do, thanks again!