I'm not sure I understand the question. By 'ordinary' do you mean non-clustered?

I understand that all items in a non-clustered index will include a reference to the related item in...

But there aren't two referenced columns, the modified query is only referencing the primary-key column - hence my question.

I understand clustered and non-clustered indexes.

The Name column is not being referenced in the query, so why would SQL Server reference the non-clustered index on the Name column?

I wanted to update this thread to let you know what I've implemented and to thank you for your ideas and input.

@scott - you got me thinking about...

Hi Scott

Yes, ProductID is the nvarchar(60) and no, it doesn't need to be nvarchar. I've been reluctant to change it because of the implications for other tables/SPs - would it...

Thanks for your prompt responses.

@colin - I implemented this and the time cam down to around 16mins, which is a big improvement, thanks.

@yayomayn - I'm concerned by what...

Thanks again Gail. I've read your post and watched a video you linked to - very useful.

I'm a bit confused about stats now, as DTA recommended creating lots (19 groups?),...

Hi Gail,

Thanks for your reply.

Does it matter which - drop or disable? Is one better than the other in this scenario?

I've read 'Disabling an Index' in 'Stairway to SQL...

Thanks for your comments.

The MERGE option is appealing because of its simplicity and the fact that it completes the whole process in one pass. It also enables bulk load from...

I just ran upgrade advisor and it seems the only potential issue is with full-text search. I'm going to download a copy and give it a try.

Thanks,

Paul

GSquared (7/19/2011)

---

Yes, Merge will do what you need. Yes, it has, in my tests, performed at least as well as separate statements, if not better.

There should be no need...

Thanks for your detailed response.

You may want to change the CommandTimeout to prevent the timeout. With table growth will come longer run times. Prepare your user's expectations with a "Please...