You're welcome.

rbajimaya (4/22/2010)

---

Thx Jason for such a sqift response. It works as expected.

I still ahve a question though, will it work when there are missng records on either tables, ie,

You may...

Steve Jones - Editor (4/22/2010)

---

Do you mean can you upgrade to R2 with Enterprise and use more than 8 CPUs? No.

If you have a 16 or 32 CPU box on...

Grant is spot on. He has covered both ends of the issue.

If you remove the calculation and just replace with

Isnull(t2.FC_Qty,0)

That should do it for you. This is due to fc_qty not being in both tables.

What do you consider to be an invalid object?

Select t1.Customer_Group,t1.Stock_Code,t1.Whse_Code,t1.YYYYMM

,ABS(ISNULL(ISNULL(t1.Shipped_Qty,0) - ISNULL(t2.FC_Qty,0)/t2.FC_Qty,0)) as FC_QTY

,t1.Shipped_Qty

,'T1 Left'

From #T1 t1

Left Outer Join #T2 t2

On t1.Customer_Group = t2.Customer_Group

And t1.Stock_Code = t2.Stock_Code

And t1.Whse_Code = t2.Whse_Code

And t1.YYYYMM = t2.YYYYMM

Where ISNULL(t2.customer_group,'') = ''

And ISNULL(t2.stock_code,'') =...

If it is any indication, my two blogs on the topic (that had links to the threads) saw spikes today. The more recent blog saw a significantly higher spike...

😎

To find what may be causing the log and tempdb growth refer to this article.

http://www.sqlservercentral.com/articles/Log+growth/69476/

Congrats and you're welcome.

This is a great article. Highly informative and is helpful in a decision I'm looking to make currently about compression.

jcrawf02 (4/22/2010)

---

Loved my...

An entry is only created in the metadata, of that view, for an index after the index has been used. If the index has not been used - it...

What is twapperkeeper?

I'm sure it is supposed to bring back memories of the Trapper Keeper (how many here had one of those?).