Only on the join. But it just...

ChrisM@Work (8/17/2016)

---

It sounds like one or more of the join columns are missing from whatever index is chosen, which would go some way to explaining the poor row count estimate...

Lowell (8/17/2016)

---

whenever the difference between estimated rows and actual rows is off by a lot(order of magnitude or more,

it usually means the statistics are out of date enough to adversely...

ChrisM@Work (8/17/2016)

---

Luis Cazares (8/17/2016)

---

Brandie Tarvin (8/17/2016)

---

Eirikur Eiriksson (8/17/2016)

---

😀

...just managed to save...

JarJar (8/17/2016)

---

i'm not clear on something about the AlwaysOn failback.... say we failover to our DR site after an outage on our primary site. the outage lasts for...

Huh...

So I'm troubleshooting code that goes over a linked server. I've pulled it down to our non-prod environment, removed the linked server name from the code, and am running it...

I have apparently missed the...

Steve Jones - SSC Editor (8/16/2016)

---

Brandie Tarvin (8/16/2016)

---

Has anyone here used GitHub?

If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be...

WilburBud (8/12/2016)

---

Hi Brandie,

I get similar log entries when our security folks are running scans:

Error: 17836, Severity: 20, State: 17.

Length specified in network packet payload did not match number of bytes...

Ahha!

I had a coworker look into this also. He determined (and called our network team to verify) that it is "network scans from the switches" that is causing this. They...

And, on another note, guess what I'm rolling back today?

Sigh. You only have 10 days post install, folks. It's a new "feature" in the Anniversary update.

Has anyone here used GitHub?

If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?

We're apparently getting it at the...

ThomasRushton (8/15/2016)

---

GilaMonster (8/11/2016)

---

Brandie Tarvin (8/11/2016)

---

3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against...

GilaMonster (8/11/2016)

---

Brandie Tarvin (8/11/2016)

---

3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against a...

I don't think I've ever seen a spill warning before I moved to SQL 2012. Now I seem to be spotting them all over the place. I really wish I...