Sorry, gotta ask the stupid question.

What should I look into tuning to reduce logical reads? Would you please direct me to a good article?

Thanks for a quick response.

It update columns used in a non-cluster index; a where clause has a column that is part of the same non-clustered index.

Sorry, I didn't look...

Grate article!

You should put all of your articles in a book if you don't have one already. I will definitely buy it. Your English is a mercy for...

Love it! Thanks!

Excellent article!

The only thing I would add is "getting used to being blamed". 😛 Network sucks, it’s DBA’s fault. SAN collapse, it’s DBA’s fault. Programmer updated...

Thanks to my insomnia…I read the comments after reading the whole article.

Thanks the author for posting this and many thanks to the experts for the corrections. ...

hmmmmmm......experts must be on vacation or sick of my questions.

Anyway I don't need answers for this now. ^_^

> Picking a data type based solely upon an

> unverified performance statement is not

> usually the best idea.

I agree and I plan to test that myself, but...

BTW, the lenght will be 15-30, not 20-23 in my first post.

Thank you for responses.

Data will be all numbers and it will be vary from 15 to 30 digits. So it's not fixed-length and it will join to...

Thanks everyone!

I personally prefer a<>b, but we have a senior programmer at work who loves not(a=b).....not(Is Null).....not(whatever). I can't just say it's difficult to debug the code...

Thank you everyone for the responses. There are jobs checking these staging tables every 15 minutes to get the data to insert into the fact tables. So...