Playing a little bit, I think your data may be a bit messed up. In you BULK INSERT you tell it to start at row 2, this tells me...

salma.pinky (2/10/2013)

---

GO

Use test

DROP TABLE PDTEST

create table pdtest

(

CustID INT IDENTITY(1,1),

work_phone_extension varchar(5),

residential_postal_or_zip_code varchar(30),

residential_street_address_line_1 varchar(30),

residence_phone varchar(17),

work_phone varchar(17),

name_part varchar(30),

mailing_city varchar(20),

mailing_postal_or_zip_code varchar(30),

mailing_street_address_line_2 varchar(30),

mailing_street_address_line_1 varchar(30),

...

First, you will need the following function to run my code down farther below:

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 2/9/2013 1:22:37 PM ******/

DROP FUNCTION [dbo].[DelimitedSplit8K]

GO

/****** Object:...

kylemkr85 (2/8/2013)

---

Thanks for the quick response, however, I am receiving the following error below:

Msg 145, Level 15, State 1, Line 1

ORDER BY items must appear in the select list if...

At this point, I will bow out and defer to Paul. He has spent much more time than I digging into these things than I and has a much...

Give this a shot:

SELECT DISTINCT

wcv.contact_name

,wcv.contact_organization_name

,wcv.workitem_title

,wcv.workitem_number

,wcv.workitem_created_on

,wcv.assigned_to_worker_name [Assigned...

You still only have a total of 12 cores, the other 12 cores are hyperthreads and they should not affect the number used by SQL Server, but I may be...

Roger Sabin (2/8/2013)

---

So, you are saying that SQL Server determined --

the cost of finding a few records (using second index) + lookup for other fields

was greater than ---

the cost...

Brandie Tarvin (2/8/2013)

---

Lynn Pettis (2/8/2013)

---

Roger Sabin (2/8/2013)

---

I understand what's been said.

But I still don't see why the first index is more "correct" when it requires trolling through thousands of records...

L' Eomot Inversé (2/8/2013)

---

Lynn Pettis (2/8/2013)

---

Not really, other than having someone call me one...

Roger Sabin (2/8/2013)

---

I understand what's been said.

But I still don't see why the first index is more "correct" when it requires trolling through thousands of records to find just the...

Not really, other than having someone call me one here on the forums.

Am I (shudder) an idiot?

This is a professional site and this is totally uncalled for.

Really???? Look again at your first post, I quoted it in mine.

Your statement from your original post, emphasis...