Thanks for all the updates. Some very useful information!

Just wondering if either of the two posters experiencing this issue got any further with MS support on it?

I'm having what appears to be a similar issue - PLE crashes...

Thanks wolfkillj,

That's essentially what I was looking for with regards to the optimizer determining the best query plan. I've always been wary of scalar functions, but these particular ones always...

Hey Craig/Alex,

I'm still waiting to hear back (from management) on how much of the schema I am able to post here.

I'm actually not so much interested in the particulars of...

Hey Craig,

I'm not sure I could post them in a useful format, if you're looking to try and re-create the actual problem. There ends up being quite a few foreign...

It's also only one of twelve similar columns on the same table, and that table currently sits at 19.7 million rows. Even if we could index each of them, I'm...

Hey Alex,

I've added the .sqlplan files to the original post... Thanks for your response!

Hey Ron,

It's interesting that I came across your article when I did, as I'm currently cursing SSIS on a regular basis in my day to day worklife.

I've found in practice...

It could be that they're doing something in addition to the text encoding, or maybe they've modified the original to create their own encoding method. You're probably best off to...

SJanki (9/16/2011)

---

That looks like UUEncoding, I'm not sure how you'd decode that in SQL. There are command line utilities to uudecode data though, so if you're using SSIS maybe you...

SJanki (9/15/2011)

---

The PDF file data in the nText column of the 3rd-party application looks like this-->

begin 660 O M)5!$1BTQ+C0-)>+CS],-"C<R(#`@;V)J#3Pa+TQI;F5A<FEZ960@,2],(#8R M,3,W-B]/(#<T+T4@-3(Y-30O3B`Y+U0@-C(P.3,Y+T@@6R`T.#@@,3@U73X^

I think it is encoded , because it is starting...

Evil Kraig F (9/14/2011)

---

Kevin Dahl (9/14/2011)

---

Is it possible that in the ntext -> nvarchar conversion something got truncated? nvarchar has a max of 4000 characters, which is not an awful...

Maybe as Kraig suggested the data is corrupted in the 2005 db before you're converting it? Or perhaps the 3rd party app may be encoding it somehow?

Are you able to...

Is it possible that in the ntext -> nvarchar conversion something got truncated? nvarchar has a max of 4000 characters, which is not an awful lot of space for most...

LutzM (9/10/2011)

---

No and yes.

Virtualization cannot cut the absolute CPU power an application requires. But it...