anthony.green (4/20/2012)

---

SkyBox (4/19/2012)

---

One of our systems (AX 2009) doesn't allow "included columns" on indexes, so with that in mind, I want be sure that those indexes aren't covering too many...

GilaMonster (4/18/2012)

---

These 4 can be replaced with one index

_dta_index_line_item_disposition_5_1662628966__K1NONCLUSTERED00order_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_9987NONCLUSTERED00order_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_32NONCLUSTERED00order_numberupdate_dtm

_dta_index_line_item_disposition_6_1662628966__K1_K15_5379NONCLUSTERED00order_number, date_shippedNULL

Single index on OrderNumber, DateShipped include UpdateDTM

These 4 can be replaced with one index

_dta_index_line_item_disposition_5_1662628966__K1_K2NONCLUSTERED00order_number, line_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_K2_18NONCLUSTERED00order_number, line_numberquantity_shipped

PK_line_item_disposition__order_number__line_number__backorder_numberCLUSTERED11order_number, line_number, backorder_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_K2_K8_18NONCLUSTERED00order_number, line_number, backorder_numberquantity_shipped

Single index...

Lynn Pettis (4/18/2012)

---

SkyBox (4/18/2012)

---

I've attached another file of indexes on a table that could use some consolidation.

I see a couple that are obvious, but would appreciate any feedback. Just a...

I've attached another file of indexes on a table that could use some consolidation.

I see a couple that are obvious, but would appreciate any feedback. Just a quick look if...

Thanks for all the advice.

That query is exactly what I needed! I re-attached the sheet with the columns (ordered) for each index (not stat), also listing included...

Do either of you know a better way to compare indexes or know of a utility?

SQLKnowItAll (4/17/2012)

---

Lynn Pettis (4/17/2012)

---

SkyBox (4/17/2012)

---

S_Kumar_S (4/17/2012)

---

25 indexes on an OLTP table is quite high. You may also want to look for partial duplicate indexes which can be merged with other...

There are a lot...

Yes, this is a concern of mine. I actually have a spreadsheet/log that records tablename, index, reads, writes, fields in index, date dropped, etc.

I can use this to re-add...

Jack Corbett (2/21/2012)

There's nothing wrong with an app using Windows Authentication. As a matter of fact that's the best way to do it. You just need...

Finally setting up and testing this.

What about end users that run apps locally? If using windows authentication (SSPI), how can I allow users or AD domain groups...

Thanks for all the advice. Good call on the scripting - actually have a good start on it already.

That's great information Jack. It's difficult to scope this without a list of their apps - based on the list I have so far, there will be about 25-40 apps...

Jack Corbett (1/26/2012)

---

In both cases I'd set up a developer role or roles in SQL Server and assign developer accounts to those role(s) as needed. If possible I...

Dev (1/26/2012)

---

I agree with jack. But I have few questions, answers to which might change my course of action.

•How many applications are there in total?

•Are these home...