Viewing 15 posts - 14,536 through 14,550 (of 19,560 total)
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 5:50 pm
What do you consider to be an invalid object?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 5:36 pm
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,'') =...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 5:32 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 5:01 pm
Grant Fritchey (4/22/2010)
Should have been... I think she gave Elektra lessons.
😎
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 4:28 pm
To find what may be causing the log and tempdb growth refer to this article.
http://www.sqlservercentral.com/articles/Log+growth/69476/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 4:11 pm
Congrats and you're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:48 pm
This is a great article. Highly informative and is helpful in a decision I'm looking to make currently about compression.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:45 pm
jcrawf02 (4/22/2010)
CirquedeSQLeil (4/22/2010)
jcrawf02 (4/22/2010)
woohoo! Brent's coming to cowtown!What is twapperkeeper?
I'm sure it is supposed to bring back memories of the Trapper Keeper (how many here had one of those?).
Loved my...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:36 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:27 pm
jcrawf02 (4/22/2010)
woohoo! Brent's coming to cowtown!
What is twapperkeeper?
I'm sure it is supposed to bring back memories of the Trapper Keeper (how many here had one of those?).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:23 pm
Penn State Nittany Lions
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:17 pm
Jacksonville Jaguars
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:11 pm
tew (4/22/2010)
Thank you for the quick reply.
I was using a similar approach, but during testing turned up some weird results...
Here is a little sample which shows my confusion...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:11 pm
As samples of joining the two tables together, here is a script by Glenn Barry from his DMV a day series.
-- Possible Bad NC Indexes (writes > reads)
SELECT OBJECT_NAME(s.[object_id]) AS...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 22, 2010 at 3:08 pm
Viewing 15 posts - 14,536 through 14,550 (of 19,560 total)