I still say 'bind to' - no doubt some young upstart developer like Flo will set us both straight...:w00t:

RTF conversion is something I have happily managed to avoid so far,...

Hey Barry,

Good point about the cursors. I had to use some a little while back, and felt dirty afterward 😉

Don't ease up on the verbosity for my sake -...

Steve can't afford me :laugh:

Well I think we can agree on this much: an occasional requirement to split a string isn't a good enough reason to enable CLR

But to get the most out of...

I'm tempted to just add a column with the IDENTITY property as PK and be done with it 😀

Barry,

I understand where you're coming from - and you certainly didn't make a pig's breakfast of it - I'm just conscious that not everyone reading the thread has your level...

It would be interesting to know what the cause of the high plan count turned out to be in your case -, if you get chance to post back about...

Wayne,

Thanks for that. I'm a bit old-school and also include an INDEX(0) too. I was rather hoping for a quirky implementation for the updated requirements though, the ones...

On second look, it appears that you are mis-interpreting the output of DBCC PAGE.

As an optimization, when SQL Server changes the type of a column, it often just adds a...

Barry,

Primarily, I was responding to your post that seemed to suggest that rewriting the process to remove the loop was somehow worthwhile.

Replication has many features (e.g. parameterized row filters) which...

RBarryYoung (2/21/2010)

---

This explanation is not exclusive of being disk-bound Paul, in fact they are likely both true. And I would give a 90%+ likelihood to it being disk-bound based...

Yes, it is an excellent series. ...

So, would anyone like to post a correct quirky-update solution to the updated requirement, just for completeness?

If not, I'll have a crack. Not fussed though, I've posted quite enough...

Interesting point. I rather focussed on the need to...

No worries - it's a question that most poeple ask at some stage.

One day, SSC will have a...