I can't resist it.

You lose physical/hardware redundancy because water leaking onto a box running four VMs downs four servers.

In Active/Active you can run at close to full tilt so long...

True. It has been a fun discussion. We clearly disagree and I guess that's ok.

andrew.hatfield (4/27/2009)

---

This is a hard discussion to have,...

andrew.hatfield (4/27/2009)

---

Generally, you virtualise a number of systems in a cluster / farm. So you would benefit from a number of systems reducing from one physical server each to...

...or marketing deals :laugh:

andrew.hatfield (4/27/2009)

---

Looking at your example and highlighting that it is is very light on details, I wouldn't consolidate...

Hey good answers Flo.

Never be afraid of posting theoretical or odd examples of stuff without a production requirement!

And yes there is always someone that knows more about a given subject...which...

@Phil - Jeff convinced me that posting compiled code was a no-no. Even if tools like .NET reflector are available. Maybe Adam will post a script for you*...

Adam Machanic (4/27/2009)

---

NVARCHAR(MAX) for both input and output? What is the use case? Just to be clear, the issue is only NVARCHAR(MAX) on output -- it's fine to...

Thank you to whomever fixed the formatting on this page!

I had to scroll right about 50 metres to find the reply button earlier... 🙂

@Flo: Yes scripting is easy, but if...

Phil Factor (4/27/2009)

---

Am I right in thinking that it is expecting a single-character delimiter? If so, it is not strictly comparable, as Flo's original problem involved a two-character delimiter. Persumably,...

Dang but Adam posts fast!

Here's the link to his blog entry that I was going to post:

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx

Jeff is going to love this 😉

Cheers,

Paul