http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

There's no way I'd ever do that job from a forum.

Hire pro.

So the log file is too small and you want him to shrink...

Why do you think I haven't replied... not going to waste 3 hours on a 5 minutes problem.

possibly... but you might as well use bcp out and maybe try to edit the html file after is it's not 100% correct.

muthukkumaran (5/20/2011)

---

sqlnaive (5/20/2011)

---

Thanks Gail. Nice idea. I'll check that out with execution plan and surely post my findings to this post.

Ninja, though i liked your idea, but still will test...

I can't even recount the bugs...

We can't do that unless we see the rest of the code and the code of the calling objects.

Then please post both plans (the correct prod one and the incorrect dev one).

Are prod and dev exactly at the same level in the sps and cus?

There's the obvious case option.

In my question I'm wondering about a single occurance as the first character... maybe I'm just overthinking this atm!

Any special way to make your trick work when there are negatives numbers too?

That's probably because there's no data in cache and the server must read it from disk. So the first run is aweful and then it gets 100 times better...

Well I can't help anymore at this point. Good luck!

Or I didn't fully understand the real newbieness level here :-D. I just hope he got what he needed.

GilaMonster (5/19/2011)

---

Ninja's_RGR'us (5/19/2011)

---

skcadavre (5/19/2011)

---

Not too difficult - there are two of us that work on the database servers and it wasn't me....