Jeff,

I had a reply just about done then I hit the back button.. So here is the really short version..

I want the developers reading this to know that all...

And I gotta say that computed column performs pretty well, its too bad that SQL doesn't think its deterministic because it could then be persisted..

I got to thinking that there...

Ok, I think Jean-Sebastien might have me..

String to varbinary

(100000 row(s) affected)

SQL Server Execution Times:

CPU time = 547 ms, elapsed time = 1481 ms.

SQL Server...

You may be right, I did 10000, which I went back to the article and it mentions 10,000 loops, but doesn't say how many rows. I see that you...

and the conversion to string from varbinary is also rockin fast

(10000 row(s) affected)

-- Output of statistics time on for 10 runs in a row

SQL Server Execution Times:

...

Well it looks like conversion from a string to a varbinary(4) is rockin fast with SQLCLR..

(10000 row(s) affected)

-- Output of statistics time on for 10 runs in a row

SQL...

Good point... No flames... just thoughts.... If all you intend to do is split the octets, then the six line T-SQL solution that uses PARSENAME is almost as fast, requires...

I was going to see about writing it tonight to see. I just wish I didn't have to do it in VB.net express, I don't have access to my...

Bump..

Didn't show up in active threads.. How odd..

CEWII

Guys, I just got to thinking about this, but it seems this kind of conversion is right up SQLCLR's alley, once it is in memory I would think it is...

Is this a 24/7 app? When is your normal maintenance window?

CEWII

As far as inner joins, I haven't experienced a difference. The argument is that the ANSI Join syntax clearly seperates join logic from filter logic, and I can see...

Thanks.

CEWII

Bob Hovious (8/25/2009)

---

Having reread the last part of your last post: Yes, you did, Elliott. 🙂

I saw your opening line about not really suggesting it and thought...

Actually Lynn, it is a little smoke and mirrors.. I'm working on an article related to Synonyms as border objects, which is what you are suggesting. However this...