What inefficiency does sharding & partitioning attempt to address?
This should get you started to wonder more:


The Basics of Database Sharding
Shard (database architecture)
Partition (database)
SQL Server Table Partitioning: Resources
SQL Server 2005 Partitioned Tables and Indexes


A lot to read but will give you all the answers that you're looking for!