These are some really good suggestions. I will try these and let you know if i see any performance gains or have any other questions

I have the following questions

1. What does SARGable mean?

2. Wouldn't normalization decrease performance, since it would involve joining of multiple tables?

3. Would partitioning the table help?

Thanks