wendy elizabeth (3/30/2012)

---

This history table will have one index based upon an identity column and 2 rows that are foreign keys to two other tables. there will be about 4,000...

Z1024 (3/29/2012)

---

For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from a heavily...

DBA_Dom (3/30/2012)

---

Yes, I have experience with creating a nonclustered index with the same column as a clustered index. For example:

table1 (col1, col2, col3, col4, text1, text2, text3, date1, date2)

clustered index...

OK, 32-bit OS without the 3GB switch or AWE enabled. Your SQL Server is using as much RAM as it can get, ~1.6GB, for how it is configured. This means...

PS posting as text directly onto forum is fine too

Please attach the results as a text file, or image screenshot. Opening Office docs from the web is against policy. Thanks.

Hel (3/30/2012)

---

opc.three (3/30/2012)

---

DBA_Dom (3/30/2012)

---

One other advantage I have seen with having a clustered index on a specific column and then also have an non clustered index on the same column...

DBA_Dom (3/30/2012)

---

One other advantage I have seen with having a clustered index on a specific column and then also have an non clustered index on the same column is that...

The only way to ensure the data is not scrambled when inserting into a table is to reduce the "bacth commit size" to 1. Whether bcp, SSIS or BULK INSERT,...

Erland has done deep analysis on this topic. From Arrays and Lists in SQL Server 2008: Using Table-Valued Parameters > Performance_Considerations (underlines added by me)

As you have understood from the...

That's an awesome list, but we do not even know the type of DBA role we're talking about here. Level 1 / Level 2 / Level 3 DBA that handles...

Please post the results from your instance:

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS...

Please post your SQL Server Edition and build number too, for future reference:

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

...

If you post the DDL we can help you identify indexes worthy of consolidation or elimination.

Hi mohan.bndr, It will depend on the type of...