ChrisM@Work (8/18/2016)

---

Brandie Tarvin (8/18/2016)

---

Brandie Tarvin (8/18/2016)

---

Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the...

Brandie Tarvin (8/18/2016)

---

Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE...

Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE clauses. ...

JarJar (8/18/2016)

---

i think i got it now. this was a missing piece of the puzzle for me. if the db remains in the availability group then it continues to...

ChrisM@home (8/17/2016)

---

If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data reader operator...

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...