Jeff Moden (12/21/2016)

---

CELKO (12/14/2016)

---

Let's have a look at the ever so humble Tally Table. For those that don't know how to create one, here's the code to do so.

...

Jeff Moden (12/21/2016)

---

So, ORDER BY doesn't necessarily do anything but guarantee the order and it certainly doesn't guarantee the SELECT will become a cursor because the SELECT is already a...

whenriksen (12/21/2016)

---

Here you just scare people...

Here is something to start with:

SELECT ID, FromValue, ToValue

INTO #Periods

FROM (

SELECT 1, 2.1, 8.0

UNION

SELECT 2, 3., 4.5

UNION

SELECT 3, 4., 10.

UNION

SELECT 4, 9., 20.

) I (ID, FromValue, ToValue)

SELECT...

Indianrock (12/14/2016)

---

Yes ORM-generated sql. Ours is a version called Domain Objects written by a former developer here. Others include Entity Framework and Hibernate. That sql code...

ScottPletcher (12/15/2016)

---

I guess I don't see why that's so much worse than a non-bit comparison of "status = 8" or "code1...

Sioban Krzywicki (12/15/2016)

---

Jeff Moden (12/14/2016)

---

Who's going to...

etl2016 (12/15/2016)

---

okay, I think I got the difference when i did the hex dump using convert(varbinary(max), sourcecolumn)

At source, the content looks like the character "En dash" with ASCII HEXcode...

Check hex view of your inbound string.

Chances are that hyphen is not actually a normal hyphen but in fact some UTF8 hyphen.

Grant Fritchey (12/15/2016)

---

So 36% of people thought that either: You don't need to compare them since the graphical plans are the same, which is blatantly false, or that You can...

Sioban Krzywicki (12/14/2016)

---

Sergiy (12/14/2016)

---

Then they are not...

We can blame the ORM tool for everything (probably even deserving), but in this case, I reckon, the query it's generated only reflects the mess in the code upstairs.

What a weird code!

.... SERVICED_COLLATERAL_GROUP_ITEM AS ServicedAccount14

...

Then they are not needed.

Koen Verbeeck (12/14/2016)

---

Igor Micev (12/14/2016)

---

Nowhere in the question is stated that the SSMS is 2016 version. "Compare Showplan" is not available in the lower versions.

So the answer is not...