gives a decent introduction to, and overview of, the War of the Spanish Succession. Even the Wikipedia entry of the conflict is pretty decent.
If you look for a good book, I am afraid there is no real decent English language book on war of the Spanish Succession. Most English language works focus on Marlborough, Blenheim, Marlborough again, the evil Dutch deputies, the other evils obstructing Marlborough's ambitions, more on Blenheim and some odds and ends on Marlborough.
In Dutch language, the standard work is 'Het Staatsche Leger', the history of the army of the Dutch Republic. In particular the part covering the WSS is very good. Also, Olaf van Nimwegen's thesis on logistics and subsistence during the WSS gives a good overview of the conflict. In German language, the General Staff of the Austro-Hungarian Empire published a multi-volume work on the campaigns of prince Eugene of Savoy. The advantage of this work is that is focuses on all theaters: Flanders, Upper-Rhine, Italy and Spain. As the other conflicts, not directly related to the WSS but certainly of influence, are also covered, one can get a could grasp of the complexities.