Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-05 Thread Agus Riyadi
e Group > > People - Partnership - Solutions > > > > > > > > *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: > axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *Agus Riyadi > *Sent:* 04 March 2009 07:27 > *To:* axapta-knowledge-village &g

RE: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-05 Thread Malcolm Burtt
roups.com] On Behalf Of Agus Riyadi Sent: 04 March 2009 07:27 To: axapta-knowledge-village Subject: [Axapta-Knowledge-Village] Create index with first column not dataareaid Dear all, Using sql server database engine tuning advisor, I got a recommendation to add new index with the

Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread Agus Riyadi
l. > > > > > > From: Agus Riyadi > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Wednesday, March 4, 2009 9:22:32 PM > Subject: Re: [Axapta-Knowledge-Village] Create index with first column not > dataareaid > > > Thanks James,

Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread Varden Morris
Riyadi To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 4, 2009 9:22:32 PM Subject: Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid Thanks James, Yes perhaps this is not relevant to recalc/closing because there are users activity during recalc which

RE: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread James Flavell
9 11:33 To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village@yahoogroups.com> vill...@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid Hi Varden, Thanks for input. This comes from the profiler file during inventory recalculation process, so

Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread Agus Riyadi
ons >> presented in this email are solely those of the author and do not >> necessarily represent those of the company. Finally, the recipient should >> check this email and any attachments for the presence of viruses. The >> company accepts no liability for any damage caused by any v

RE: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread James Flavell
_ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Agus Riyadi Sent: 05 March 2009 11:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread Agus Riyadi
d > by this email. > > > ------ > *From:* Agus Riyadi > *To:* axapta-knowledge-village > *Sent:* Wednesday, March 4, 2009 12:27:29 AM > *Subject:* [Axapta-Knowledge-Village] Create index with first column not > dataareaid > > De

Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-04 Thread Varden Morris
transmitted by this email. From: Agus Riyadi To: axapta-knowledge-village Sent: Wednesday, March 4, 2009 12:27:29 AM Subject: [Axapta-Knowledge-Village] Create index with first column not dataareaid Dear all, Using sql server database engine tuning advisor, I

[Axapta-Knowledge-Village] Create index with first column not dataareaid

2009-03-03 Thread Agus Riyadi
Dear all, Using sql server database engine tuning advisor, I got a recommendation to add new index with the following scheme : CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Is it possible to achieve that in Ax ? As far as I know Ax always add dataare