Fandy08 (12/11/2015)

---

GilaMonster (12/10/2015)

---

No. Not bad plans. Plans which run more data through the UDFs than previously, resulting...

GilaMonster (12/10/2015)

---

No. Not bad plans. Plans which run more data through the UDFs than previously, resulting in...

Orlando Colamatteo (12/8/2015)

---

agree it is counterintuitive. rebuilding indexes amd stats (even if only a subset of stats) should not hurt things.

any noticeable changes (increases or decreases) in data volumes on...

Alan.B (12/8/2015)

---

On a side note, and I don't know if "the sudden slow down" happened when after the scalar udfs were added, but Scalar UDFs kill parallelism. Often the whole...

So, definitively, the reason must have been bad plans after reorg of indexes, it remains mysterious for me how could things go fast before, with fragmented tables and stale stats,...

Yes, I checked, a few column statistics are older than those of indexes, do you mean Orlando that performance slow down can be caused by these differences on update date?

Thank you Gail, it must have gone like you said, unfortunately now I can't verify if the stats were stale before, I tried asking to developers the percentage of daily...

I rebuilt all indexes, non only PKs, that causes stats update automatically, is it true?

More or less at the time the problem occurred I rebuilt PKs, things should have gone better, that's what I was thinking.

That could have surely changed execution plans, but making...

I made some test with varbinary(max) datatype (instead of image) and the following sequence works, LOB data is released and canceled from database.

So the problem is limited to (deprecated) image...

This is my situation

table_name index_idtypetype_desc total_pagesused_pagesdata_pages

TBL_EMAILOUTBOUND_DSC11IN_ROW_DATA678967796745

TBL_EMAILOUTBOUND_DSC12LOB_DATA ...

Thank you all!

I imagine this means that this feature doesn't exist ......