Wow! I already forgot about this post! Thank you, Wesley! It's very useful to know. I should read this IO white paper, looks interesting.

Denis

Hi Gail,

Thanks for your input! Good point, the procedure is cached as a whole with IF conditions in the plan.

Denis

Thank you, Sean. It's good to know!

Denis

Sean,

Didn't know that either! That would be great! I really appreciate it.

Denis

Bill,

Thank you! As always -- it depends and there is no best way 🙂 Didn't know about the SELECT DISTINCT, do you know where I could read about this? I'd...

Sean,

Yes, I am aware about the possibility of dirty reads while using the NOLOCK hint. I really don't care about them in this case. I needed avoid any locking.

Denis

Luis, thank you for your reply! Gail ROCKS 🙂 I've been reading her blog for a while now! I think I have an idea now how to deal with this.

Denis

Hi Wesley,

Thank you for the info! I understand that it has been a while since you wrote this article but I hope you could answer my questions.

My company just bought...

Good point! Thank you, Gail.

Hello Gail,

Thank you for your reply. Is this what you were looking for?

CREATE NONCLUSTERED INDEX [IX_Records_RecordType_DateCreated] ON [dbo].[Records]

(

[RecordType] ASC,

[DateCreated] ASC

)

WITH

(

PAD_INDEX = OFF,

STATISTICS_NORECOMPUTE ...

You're right! I'll need talk to developers to see what queries they're planning on running and then look at the execution plans.

Denis

Thank you, guys! I think I see my options now. I guess it's time to play now.

Denis

OK! If I follow your suggestion (which I'd really like to do), how will I store the combinations of the IssuerId and DataTime columns? As far as I know, I...

Thank you, Sean! I appreciate your help.

Denis

Thanks for your reply! Everything (including the column names) comes from the external feed. I need to have both of them as the primary because there will be instances of,...