Some explanation for the CLR functions.[/b]

It seems that SQL Server doe many optimizations for SUBSTRING functions like “SUBSTRING(s.definition, N, 2) = @crlf”. I don’t think that it really copies every...

Hi!

So finally I’m done with all my tests. This post will contain the main information about the tests. I will separate the results into more than one post to hopefully...

Stay patient, please. 😉

I just want to post it together with the other functions. I also did some performance improvements...

Hi Barry

The source totals...

Hi Jeff!

Some intermediate results of my current tests. Some new CLR functions joined the competition ;-).

SourceType Description ...

Old? We? I?

Let me quote a wise man:

BWAA-HAA!

Hi Paul

Chunks? Your suggestion was...

Derek Dongray (4/17/2009)

---

Of course, when I thought about it, the Perl to split a string would simply be.

@lines = split('\ n',$string)

Since I usually need to do more complex matches I...

Derek Dongray (4/17/2009)

---

Phil Factor (4/17/2009)

---

Derek, not me, Florian. All I'm doing is showing you guys how to test the idea! Let's get some detail on the relative performance of all...

Paul White (4/17/2009)

---

Hey Flo!

I'm surprised no-one has suggested sending the entire text to split to a CLR function in an XML parameter, generated from a SELECT with some kind of...

Hi Phil

Oops... Sorry!

All I'm doing is showing you guys how to test the idea! Let's get some detail on the relative performance of all these...

Hi Phil

I'm with Paul. RegEx is a powerful tool for complex searches, replacements and validations in text. For a simple text a standard string.Split or a char loop (outstanding test...

Hi

It depends... If you have queries like "Description='MyDescription'" your index will work fine. If you usually have queries like "Description LIKE '%PartOfDesc%'" you should consider to use a full-text index.

Greets

Flo

Hi

You need to specify the remote login information by sp_addlinkedsrvlogin:

DECLARE @LinkName SYSNAME SET @LinkName = 'LINK_NAME'

DECLARE @SrvName ...

Hi

In SQL2k5 it is possible by a detour over a non-unique index and a CHECK constraint:

CREATE TABLE TestCheck

(

Id INT NOT NULL IDENTITY,

UniqueText VARCHAR(30) NULL

)

GO

CREATE...