John Mitchell-245523 (8/4/2014)

---

Also, when was the last time you updated your statistics? There are massive discrepancies on some of those index seeks between estimated and actual number of rows....

Jeff Moden (7/31/2014)

---

Sean Lange (7/31/2014)

---

Jeff Moden (7/31/2014)

---

Doug J. (7/31/2014)

---

Jeff-

This:

Steve Jones - SSC Editor (7/31/2014)

---

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about...

Jeff Moden (7/31/2014)

---

Doug J. (7/31/2014)

---

Jeff-

This:

Steve Jones - SSC Editor (7/31/2014)

---

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him...

SQLRNNR (7/31/2014)

---

swasheck (7/31/2014)

---

To qualify my statement, I have no personal context for anything involving Jeff Moden and I'd welcome him. I've only perused SSC forums in the past and have...

Maybe you have more data...

Ed Wagner (7/31/2014)

---

SQLRNNR (7/31/2014)

---

crookj (7/31/2014)

---

Ed Wagner (7/31/2014)

---

BWFC (7/31/2014)

---

Revenant (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Sean Lange (7/30/2014)

---

Ed Wagner (7/30/2014)

---

SQLRNNR (7/30/2014)

---

djj (7/30/2014)

---

hot...

Awesome job posting consumable ddl and sample data!!!! I wish everyone would create posts like that. It really makes this easy to work with.

I am not quite sure what you...

ba.saidou (7/31/2014)

---

The goal here is to calculate a UPH of an activity, the activity is considered picking materials.

The issues I am running into is that as long the users are...

This is a good place to start. http://technet.microsoft.com/en-us/library/ms186243%28v=sql.105%29.aspx

The code is a recursive cte. There are tons of articles that explain how they work.

Sql server stores datetime as decimal. You can easily cast a datetime to decimal. But what is the point? What are you trying to do with it?

What part(s) don't you understand?

Evil Kraig F (7/30/2014)

---

EDIT: On a side note, I was debating on if I should do another article, this one for tech instead of soft stuff. I may have...

Evil Kraig F (7/30/2014)

---

churlbut (7/30/2014)

---

Hello,

We just had a meeting a few months ago given by a DBA to us developers...

Big advice to us was to take the Items in a...

No kidding. I sure opened a can of worms I...

Bacon