Image data (or successor types) is a bit of a pain.   I am satisfied, at this point, with the option of putting image data into it's own file group.  What I found...

OK.  Let me try a different explanation.  My database recovery model is FULL.  I do a full backup at 6 A.M.  Then, I start a process that deletes 10 millions...

After doing some reading, it seemed to be a better idea to rename the original table and create a new table set up with PAGE compression using the desired partitions...

I had thought about switching. I guess that will be my project for the weekend - load each partition as a separate table and then bring them all together...

No. It is a one time data conversion process. The BIGINT columns in the target table are INT columns in the source table.

Tom John-342103 (2/5/2015)

---

I don't have the execution plan. What I know is that after the index was rebuilt (actually, I think they updated statistics - they told me they...

I don't have the execution plan. What I know is that after the index was rebuilt (actually, I think they updated statistics - they told me they ran RUNSTATS),...

The problem was solved by running some index rebuilds. So frustrating when people aren't careful about performing routine maintenance.

We identified the offending query in the...

Igor,

That is very likely the problem then. I am helping some people with this problem and I am not the database owner. For various reasons, I don't think...

So, here is an after action report of sorts.

I received a 2 TB database containing about 225 tables where 10 tables accounted for 90% of the volume of the database....