That's a very broad question.

Basically, NoSQL solutions don't conform to the SQL standard and/or relax some of the ACID characteristics in exchange for scalability.

Somewhat relevant:
Stewart Smith: Dropping ACID: Eating Data in a Web 2.0 Cloud World - OSDC 2011 - YouTube
MongoDB is web scale