Thanks everyone. I have asked the developer to redo the query. I do not think filtered index is an option and as it is a vendor apps they build these...

I am not sure what the developer is actually trying to achive so i told him to redo his query.....but is it possible to do teh create index in a...

Thank you very much! I tried it with different column names and it errored out. So I suggsted the developers that they wil have to do with the column names...

Thank You. Now they want tokethe column names different too! Any suggestions for that?

not for writing apps. more for understanding so that troublehsooting is easy and to use in SSIS packages.

Thank You

Thank You

I have related question - can you shrink the log file if it is 99% free while the database is in use by users? I am little reluctant to shrink...