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...

If someone needs sysadmin privs their Windows Login gets it via an NT Group, or I make them a SQL Login if required by the circumstances. If I can help...

Be careful using DATEPART, output is dependent on server options.

From DATEPART (Transact-SQL) (2008 R2)

The return value depends on the language environment set by using SET LANGUAGE and by the default...