edvaldocastro (9/17/2009)

---

CirquedeSQLeil (9/17/2009)

---

When you execute it manually, does it produce any warnings?

Also, are there any other inserts happening inside this proc?

Lastly, inside the sql agent job, what is the command...

To help the situation, you should consider a clustered index for the table. To defrag the other indexes, you will need a clustered index. The clustered index can...

lmu92 (9/17/2009)

---

Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work...

drodriguez-762178 (9/17/2009)

---

Help! I have an index that is heavely fragmented. I've rebuilt all the indexes through a maintenance plan. It didn't improve the index I'm having a problem with. The...

They are microsoft solutions that will support the various flavors of SQL Server as well as other Microsoft products (it would be akin to...

A couple of options are:

Use SMS

Use...

What is your frag % immediately after a defrag? As suggested in the other thread, how many pages do you have in these indexes? What is your fillfactor?...

When you execute it manually, does it produce any warnings?

Also, are there any other inserts happening inside this proc?

Lastly, inside the sql agent job, what is the command you use...

As lowell has mentioned and from your...

This one made me pause for a sec - i was sure there was a trick somewhere in it (an extra space, some syntax or something). But straightforward it...

K - so that drives more towards having a lookup table for the fiscal month dates (my opinion).

So what all have you tried to make the summing of months work?...

What have you tried so far for the fiscal month solution?

Is the list of Fiscal Months static from year to year? If yes, you could potentially hard code those...

The tempdb data file should be set statically and use the filegrowth as an emergency backup. When trying to determine what could cause it, you could look into the...

I remember all too well what I was doing on that day as well. It was a very surreal experience watching it all day every day for so long....

GabyYYZ (9/10/2009)

---

Kit G (9/10/2009)

---

No, I haven't seen Spamalot. I probably should, I hear good things about it, just too lazy to go to an actual theater and I don't...