Here's a guide that shows you the best way to farm large titanite shards for upgrading your gear in Dark Souls 2.
The enemy you want to farm is: humanoid spider / spider's corpse in Brightstone Cove near the Chapel Threshold bonfire.
How to get there: Shaded Forest (Ruins bonfire) --> Doors of Pharros --> Brightstone Cove.