Matthias Kläy (11/28/2014)

---

Hi Alan

Thanks for this great function. One note:

SELECT * FROM dbo.PatExclude8K('123# What?!... ', '[^a-z!?.]')

returns hat?!...

So it is case sensitive, contrary to your comment in the programmers notes. I...

Did not know that this existed. Very cool.

This guy here is slightly slower than the last (and fastest) version of PatExclude8K that you posted.

ALTER...

Eirikur Eiriksson (11/6/2014)

---

Alan.B (11/4/2014)

---

Taking this one step further... Why not just replace PatExclude8K with PatReplace8k() ?:w00t:

I like the idea, tinkered a little bit with the code and got the average...

Unless I'm not understanding what you are doing you can just use ISNULL to deal with the NULLs like this:

ISNULL (<value>, 0)

You can start here: Stairway to Integration Services[/url]. I like all the stairways but this one is particularly good.

I just finished reading:

Microsoft SQL Server 2012 Integration Services

which is...

Here's a function that should do the trick:

CREATE FUNCTION dbo.SubstringBetween

(

@string varchar(1000),

@searchString1 varchar(20),

@searchString2 varchar(20)

)

/*

-- example:

DECLARE

@string varchar(100) = '[atc1.123/atc2.456/atc3.789/atc4.xyz/]',

@searchString1 varchar(20) = 'atc2',

@searchString2 varchar(20) = 'atc3';

SELECT newstring

FROM dbo.SubstringBetween(@string,@searchString1,@searchString2);

*/

RETURNS TABLE AS...

emph. mine

g.britton (11/5/2014)

---

Well....a multi-character delimiter is just a simple pattern without wildcards. So even though that's not the design...

g.britton (11/5/2014)

---

I've been using Jeff Moden's excellent Tally OH splitter for a while

http://www.sqlservercentral.com/articles/Tally+Table/72993/

In the comments it says:

Optimized for single character delimiter. Multi-character delimiters should be resolved externally from this...

Taking this one step further... Why not just replace PatExclude8K with PatReplace8k() ?:w00t:

I had to use logic from earlier in the thread but what about this for starters:

CREATE FUNCTION...

I read through this thread - very interesting...

Got me...

Eirikur Eiriksson (11/3/2014)

---

Adding a little bit of tinkering based on the operator cost results in the previous post, mainly changing from the CASE to a WHERE clause for filtering. Not...

mister.magoo (11/4/2014)

---

If you want a major duration boost, you can always slip Adam Machanic's "make_parallel" function into the mix and then you get some serious results...

Adam's function : http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx

In use...

I figured it out.

Using the DDL above I would...

-- (1) Add new file group

ALTER DATABASE temp2

ADD FILEGROUP tp2fg6;

GO

-- (2) Create new file for the filegroup

ALTER DATABASE...

Ditto what was said thus far.

I would add: Beginning SQL Server 2012 Administration 😉