CE == Cardinality Estimator.

But yes, it is a convenient abbreviation to give it other appropriate names (mostly bad names, to be sure). :ermm:

Just an aside..

Was hoping SP2 would resolve my CE 120 issues.....

Nope.

Back to CE 70. :crazy:

Exactly. Some mess. And this...

And btw, I can not even download it from a public site...

Must be my Alzheimer's getting in a way.

No, dbcc checkdb is not at fault in my case.

I was not running it at the time.

But I maybe found a possibility - other external app could be jamming...

Bringing this topic back...

We've migrated and running on ESX-based VM for this particular SQL instance.

So far OK.

Discount for high known IO latencies that we still need to fix...

This is kind of what the URL I pasted above is talking about.

So, yet another vote for taking that route - GPO over the registry.

Thanks, Brian!

Well... this is an option.

However, did not really want to have this hardcoded central location pointer (be it a file or a database) if possible. This is because if we...

OK, I found that compressing the records in a loop (I used a cursor) gets the job done with no "out of memory" issues. It is still quick enough and...

To be fair, we also can limit size of BLOBs to push through compression.

Average size of the document in our business case is about 100-300K. Those make up...

I am on SP2.

Exact build number posted above.

Really wanted to avoid 3rd party. But if they post the code, it could be useful.

Shame that M$ could not just...

A bit of a background about what I need to do:

1) need to compress some BLOBs that store binary copies of real documents (sample attached)

2) in this test run I...

An hour later I have some bad news.

As soon as I attempted to put a bit of a real load on the SQLCLR compresson and push through some real...

JoeA (3/5/2007)

Hi Yoel - I enjoyed your article on blob compression - but I believe there is a bug in the compression function...

.....I determined that the cause of the problem...

Thanks. I get it now.

It is just not obvious and not documented up front (as far as I can see).