Viewing 15 posts - 1,201 through 1,215 (of 5,590 total)
SQLRNNR (6/6/2011)
Lynn Pettis (6/5/2011)
Jeff Moden (6/5/2011)
Lynn Pettis (6/4/2011)
I am going to...
June 6, 2011 at 10:40 am
tfeuz (6/6/2011)
Here is index #1
USE [TBR3]
GO
/****** Object: Index [_dta_index_InvoiceLineItem_43_800057936__K2_K28_K17_K21_K1_10] Script Date: 06/06/2011 11:24:37 ******/
CREATE NONCLUSTERED INDEX [_dta_index_InvoiceLineItem_43_800057936__K2_K28_K17_K21_K1_10] ON [dbo].[InvoiceLineItem]
(
[InvoiceKey] ASC,
[ProductRebateCategory] ASC,
[GrossAmount] ASC,
[NetAmount] ASC,
[InvoiceLineKey] ASC
)
INCLUDE...
June 6, 2011 at 10:36 am
tfeuz (6/6/2011)
So I have done some more testing and this is what I found....
The more recent versions of the stored procedures seem to run in the 30-45 second range for...
June 6, 2011 at 9:05 am
If you add a ColToUse column to the RB_Rule table, you can change this:
SELECT @Col2Use = CASE (CalcDateType)
...
June 6, 2011 at 7:55 am
tfeuz (6/6/2011)
Found it ---We need to do string manipulation to build the SQL....
Good. As soon as I saw the error message, I started doing the head-slap thing.
For query plan re-use,...
June 6, 2011 at 7:45 am
Just be careful with global temp tables: as soon as the connection that created it goes away, the global temp table will go away also (as soon as all other...
June 6, 2011 at 4:52 am
WayneS (6/5/2011)
First, create 5 indexes on the Invoice table:1. ShipToDiscountDueDate , InvoiceKey INCLUDE ShipToKey
2. ShipToNetDueDate, InvoiceKey INCLUDE ShipToKey
3. TermsDiscountDueDate, InvoiceKey INCLUDE ShipToKey
4. TermsNetDueDate, InvoiceKey INCLUDE ShipToKey
5. InvoiceDate, InvoiceKey INCLUDE ShipToKey
I...
June 6, 2011 at 4:49 am
Alternatively, you could still do that all in one proc, but it would use dynamic sql to build a string with the proper column, then execute that string. This way,...
June 5, 2011 at 7:33 am
tfeuz (6/5/2011)
Wayne,I think I am missing something -- the invoicekey is the PK and it is clustered:
It's not you missing it, it was me. I didn't scroll down far enough...
June 5, 2011 at 7:04 am
Craig Farrell (6/4/2011)
If Jeff is willing to put his name on the line, something he considers quite valuable, to prove a point with numbers... it's worth listening to.
+1000.
+ more...
June 4, 2011 at 10:26 pm
This isn't a clustered index, and there is a clustered index on that table.
Isn't the Primary Key on this table the InvoiceKey column? (which means that it has an...
June 4, 2011 at 10:13 pm
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
June 4, 2011 at 9:53 pm
tfeuz (6/3/2011)
All;I did the requested cumulative changes and it actually got worse -- it is now at 25 seconds instead of 18....
Execution plan attached
TF
Even though time is probably the easiest...
June 3, 2011 at 10:34 pm
Ninja's_RGR'us (6/3/2011)
WayneS (6/3/2011)
Does this work?Bingo!
Thanks a mil.
NP.
June 3, 2011 at 10:14 pm
Just received a wonderful PM... someone thanking me for the help I'm doing... for someone else!
June 3, 2011 at 11:23 am
Viewing 15 posts - 1,201 through 1,215 (of 5,590 total)