OK, thanks! I appreciate the feedback and help.

I've looked through some of the suggested web searches and am going to try to break up the DBCC by tables. Not sure...

Ok, so here's the deal. This database is actually archive data only so I'm thinking of switching the DBCC on it to PHYSICAL_ONLY.

This looks like it will significantly reduce...

No, we don't have TF 2562 enabled. Did you link to a page? Not seeing it.

However, looking at the largest table (400GB) it has 10 text columns in it. :crazy:

I...

Yeah, this database has about 25 tables and a few at the top are very large and it quickly goes down from there. Paul has written quite a bit about...

Sorry everyone, I overlooked the fact that we had PAGE level compression on these tables on the old version and they new partitioned tables were not compressed!

That explains it! Thanks...

Ok, so checking I did not give you the exact details in the first post with the column count, here are the exact details, the old table has 53 columns...

Fill factor went from 90% to 80% along with change. Not nearly enough to account for increase.

Got it, thanks!

I see, that make sense. 🙂

The log would reapply the transactions but not the corrupt pages themselves. I'll be sure we have an unbroken chain going back that far enough....

@file_attachments

Ok, so I was able to run a full CHECKDB on the database over the weekend and it returned no errors. So I guess this is not a corruption issue,...

We ran CHECKDB on the restored copy of the database, which should report the same problems as the production database right? My boss is very hesitant about running against production...

Ok, the wildcards are actually working now. It must have been something else in my script throwing it off befoer I ran those statements.

As for returning variable values, I had...

Ok, thanks a lot, very helpful. 🙂