GAAAAAHHHHHH!!!!

Stop impersonating my users! Or...

Funny for the day:

http://www.rd.com/funny-stuff/work-cartoons/%5B/url%5D

You are welcome.

Thank you.

ThomasRushton (8/18/2016)

---

Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"

erm... SELECT GETDATE()

Thanks Jeff!...

I...

<headdesk>

So I realized that the date column I'm pulling from history was acting a little funny. We have some dates in August (I.E., the "order" was entered in August but...

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