I still think the answer is char(1) since the question clearly suggests that the column will not have empty or null values. In that scenario more than varchar performance wise...

I fully agree with the author. In fact I was always away from social networking sites and prefer to communicate over email, phone or in person (of course its my...

Have you changed the database recovery option to simple before shrinking the database. After shrinking, revert the recovery mode to Normal.