If this helps anyone we found one of our problems related to our heap issues:

If you just ran DELETE statements

without specifying "WITH (TABLOCK)", the empty pages could not be...

Our server is pretty active, but these jobs run during our quiet times.

Thank you for the reply regarding our 2nd question.  That does shine some more light on our issue...

It seems that with a heap table, SQL is not bright enough to reuse availble space.  We have read a few articles that claim that with a heap, all data...

I have modified the scripts quite a bit and I have log file backups scripted.  I was not too concened about log file restores because any DR will have a...

Ooops, the stored proc I was executing the INDEXDEFRAG logic, not the REINDEX. I fixed the stored proc.

All is better now, but I am still seeing extent scan fragmentation...

Thank you

We will wait patiently.

Kevin

Another thought, we centrally locate all our SQL backups on one UNC server. We are in the stage where we have more than one SQL server, but don't have...

I just ran across your set of stored procs when looking to upgrade our backup processes.

I also could use transaction log ability.

I stripped out the main components of the script...