As a veteran gamer, I pre-ordered the Dungeon Survival Guide long before it was published. Based upon the name, I expected something between the classic Dungeoneer Survival Guide of 1st Edition, and Cityscape - a book exploring new mechanics of the Dungeon setting. What I received was a sad disappointment.
This book was mostly a compendium of comments about a number of different modules and adventures that have been published by TSR and WotC over the years. Each dungeon adventure is given a 2-page summmary, with a few highlights of the adventure and general description of the setting and purpose. It has absolutely no new rules, no new insights, or no new real material at all. For a veteran gamer, the book is a complete waste.
The Dungeon Survival Guide is actually aimed at novice players, probably to get them interested or excited about playing D&D. It is full of lavish illustrations, many from the adventures in question. But the book is short - only about 60 pages. Why this book was hardbound is a mystery to me.
Since I've been gaming for over 30 years, I hardly qualify as a novice gamer. I cannot tell whether this book would entice a novice into the game, but I doubt it. A new gamer is more enticed by a good gaming group and perception of fun than a "best-of" list of dungeon adventures.
If you're a veteran gamer, skip this book. If you're a novice gamer, skip this book and buy a Player's Handbook or some dice. Either will suit you better in the long run.