TheSQLGuru (5/27/2016)

---

Alan.B (5/27/2016)

---

TheSQLGuru (5/27/2016)

---

I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and...

@Holy One,

Using complex tools that require specific knowledge in places that can also work well with something more basic, is I think just not a good idea.

Taking EF re-usability as...

Use of ORMs to shield programmeurs from the reality of their data and relational database tech, results in:

* overly complicated code (The "concise" LINQ code in the article is everything...

In addition, insert techniques matter as well.

1) If the target table is constructed as a heap, using an insert ... into ... from manner then hardly any log space...

PS.

My issue of not being able to post or comment on connect issues has been solved.

They lost part of my registration, after going trough it again, it works.

Jeff Moden (3/24/2016)

---

peter-757102 (3/24/2016)

---

@Jeff Moden,

These are two new functions I like to see, with a broader scope then just string splitting (but they are suited for it).

If I had these...

@jeff Moden,

These are two new functions I like to see, with a broader scope then just string splitting (but they are suited for it).

If I had these I...

String splitting has at least two fundamentally independent components that both require more specific attention then any full split function can provide (hence all the discussions).

Components

1. Identifying split locations in...

@jeff Moden,

I understand your position.

And I do have good reasons to want it a certain way:

1. Storing empty strings really is an edge case.

2. Casting null values to...

Jeff Moden (3/12/2016)

---

It hasn't come up yet but I'll also state that if the use of multi-character delimiters slows it down in the slightest, then it should only accept single...

@jeff Moden,

I fully agree with you on the number of parameters.

More then two configuration options on this function will make it harder to use and code containing it,...

TomThomson (3/12/2016)

---

peter-757102 (3/12/2016)

---

.....

De-serialization tasks need to work exactly in reverse to the serialization, which is:

Empty array/set/list --> NULL

One empty string or ID --> ""

Two empty strings or ID ---> ","

Array...

Jeff Moden (3/12/2016)

---

You have to trust me when I say that I already know the OUTER APPLY work around so, ultimately, it doesn't matter which way they go on the...

Jeff Moden (3/12/2016)

---

peter-757102 (3/12/2016)

---

When treating NULL as an "empty string" instead of "no string" and thus return rows for it, it is going to complicate and limits its use for...

TomThomson (3/11/2016)

---

Certainly we want to get the numbering added to this splitter in SQL 2016, but we ought to find way of avoiding treating NULL as a value rather...