Viewing 15 posts - 1,216 through 1,230 (of 5,590 total)
Garadin (6/3/2011)
1. They all fit on one line (On my screen anyways).
2. I actually know what they all are!
Very nice list though.
Is...
June 3, 2011 at 11:02 am
Stefan Krzywicki (6/3/2011)
GilaMonster (6/3/2011)
Garadin (6/3/2011)
June 3, 2011 at 10:58 am
I'll try it out on my 2005 vm tonight. However, I've never had problems saving - it's always saved all plans.
June 3, 2011 at 10:55 am
Ninja's_RGR'us (6/3/2011)
WayneS (6/3/2011)
Mr. Ninja... I know you're lurking... do you see any other things to do, or that you would do differently?
Nothing major... at this point I'd also be whacking...
June 3, 2011 at 10:42 am
Mr. Ninja... I know you're lurking... do you see any other things to do, or that you would do differently?
June 3, 2011 at 10:26 am
WayneS (6/3/2011)
On dbo.InvoiceTotalAdditionalCosts, do you have any indexes? It would benefit from:
CREATE INDEX IX_1 ON dbo.InvoiceTotalAdditionalCosts (InvoiceKey, ProductRebateCategory) INCLUDE(Amount, Type)
Don't add this one... add those INCLUDE columns to the existing...
June 3, 2011 at 10:26 am
tfeuz (6/3/2011)
Is it possible that what I am trying to do can not be optimized down to just a few seconds and...
June 3, 2011 at 10:20 am
On dbo.InvoiceTotalAdditionalCosts, do you have any indexes? It would benefit from:
CREATE INDEX IX_1 ON dbo.InvoiceTotalAdditionalCosts (InvoiceKey, ProductRebateCategory) INCLUDE(Amount, Type)
What is the definition of the _dta_index_Invoice_24_1044198770__K9_K1_K2_K92_K42_K17_3_5_11_18_19_23_43_44_117 index on the dbo.Invoice table?
June 3, 2011 at 10:04 am
Right click the graphical plan, select "Save Execution Plan As..."
June 3, 2011 at 9:41 am
tfeuz (6/3/2011)
I made all the changes requested...Altered the index order and included the column
This got rid of the table scan.
Changed the data types from 18,6 to 18,0
This got rid of...
June 3, 2011 at 9:32 am
The IN operator needs distinct values, ie. IN (1,2,3,4) or IN ('A','B','C','D').
When they are combined in one variable, it is not expanded out.
You'll need to either split them out, or...
June 3, 2011 at 9:08 am
tfeuz (6/3/2011)
Working through all the suggested changes....but the function has this syntax error:
Msg 102, Level 15, State 1, Procedure fnCalculateRuleInvoiceUnits_Single, Line 46
Incorrect syntax near ','.
I cannot really see the issue?
Whoops,...
June 3, 2011 at 8:57 am
In both procedures, and the function, change the @RuleId parameter from decimal(18,6) to decimal(18,0) to match the actual datatype of the columns.
Edit: In the RB_InvoicesToProcess and the RB_InvoicesToProcess_Moved tables, the...
June 3, 2011 at 8:45 am
Ninja's_RGR'us (6/3/2011)
WayneS (6/3/2011)
tfeuz (6/3/2011)
I dropped the redundant index
Added the new index to the rb_invoicestoprocess table (invoicekey,ruleid)
Made the change to the SP as you suggested....
It actually went from 23 seconds up...
June 3, 2011 at 8:36 am
Viewing 15 posts - 1,216 through 1,230 (of 5,590 total)