Just to draw breath and summarize a bit:

The fastest CLR solutions appear to be almost 20x at least 3x faster than the fastest T-SQL implementation so far. I think...

C# Screw (11/19/2009)

---

Hi Paul

Does this particular function with pointers put SQL server at risk?

Does the use of pointers create a memory overwrite issue?

Just curious, I have learnt so much in...

Well that's odd....

Jason, three words of advice, bro:

SEEK HELP NOW

:laugh:

Thank you Mark - a simple translation was exactly what I had hoped for. I've been meaning to look at this stuff for ever. Now's my chance!

Just to...

If you need fast and accurate results (which is also languages and culture sensitive!) consider adding a method based on TextInfo.ToTitleCase to your CLR utility library.

See http://msdn.microsoft.com/en-us/library/system.globalization.textinfo.totitlecase(VS.80).aspx for examples and...

Ok let me try to guess.

Procedure B has three different SELECT statements, each of which return a result set to the output window when run from SSMS.

What is it exactly...

So, let me be sure I understand this.

You wrote a function (in a .NET language) to read the contents of a file from disk. You then added that function...

What do you mean by 'fetch'?

If you are clear with the question, I'll be clear with the answer 🙂

So, let's quickly pass over the terrible design you are being asked to work with...and let's also walk quickly on by the deep nastiness of the new design 🙂

I assume...

Just a couple of other points that spring to mind:

SELECT INTO can be minimally logged if the recovery model is BULK_LOGGED or SIMPLE.

SELECT INTO is limited to creating a table...

Condorman (11/17/2009)

---

In the event that members of a particular sequence cannot or need not be reliably ordered, ROW_NUMBER ensures the integrity of the running total value, whereas RANK breaks the...

Condorman (11/17/2009)

---

From SQL2005 and above, I wonder how a persisted computed column would perform. The function that populates the column would only need to find the most recent running...

Not at all 🙂

Looks all good - I'll load...

Yep that covers it, but it's maybe not the clearest or most comprehensive page ever added to Books Online 🙂

There's a load more interesting stuff around the storage of the...