cook155 (4/14/2014)

---

Here is some added information that may help.

This is my local machine. I am connecting to the database Adventure works dw 2012 that i downloaded and moved to my...

I'd say that partitioning and order by helped just as much. 🙂

Just curious - what do you see when you have multiple open sales orders for the same item?

Is it what you expect?

Ville-Pekka Vahteala (4/8/2014)

---

SQLBill (4/8/2014)

---

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is...

xsevensinzx (4/7/2014)

---

Greg Edwards-268690 (4/7/2014)

---

One of the better reasons to crunch numbers in your process is that the logic is consistent.

Nothing worse than someone from above asks a question, and then...

Sean Lange (4/7/2014)

---

Ed Wagner (4/7/2014)

---

Sean Lange (4/7/2014)

---

Greg Edwards-268690 (4/7/2014)

---

Sean -

Is the grass green?

I still see white and brown around here. 🙂

Sad about the refs - kids need to learn...

One of the better reasons to crunch numbers in your process is that the logic is consistent.

Nothing worse than someone from above asks a question, and then gets multiple different...

Sean -

Is the grass green?

I still see white and brown around here. 🙂

Sad about the refs - kids need to learn the rules right.

And a ref repeating a wrong...

We ran a 50 GB cube, 500 + measures, and over 300 dimensions, on a 32 GB server.

Largest fact table was 25M + records, but as you can see, very...

+1

Although...

Lynn Pettis (4/6/2014)

---

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is now...

Ed Wagner (4/4/2014)

---

Sean Lange (4/4/2014)

---

I think I have finally officially lost my marbles. In addition to coaching 2 soccer teams, playing in 2 adult leagues and being the Cubmaster for...

SQLRNNR (4/4/2014)

---

Sean Lange (4/4/2014)

---

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

This...

Revenant (4/3/2014)

---

TomThomson (4/3/2014)

---

Lynn Pettis (4/3/2014)

---

I thought that was 2 of 3? When did this...

WayneS (4/3/2014)

---

You have until...