>When is the best time and conditions to use Views?

Really vague questions. A good use of views is to present a simplified structure to the user or to break down complicated queries into pieces.

>When is the worst examples of using Views inappropriately?

IMHO, updating data through a view.

I'm a BIG fan of all data access going through stored procedures!!

-Mike