SQL Tuning


Book Description

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.




Smoke Your Firefighter Interview


Book Description

With this book you will gain insight into the crucial part of the exam- the interview. While it is important for a candidate to focus on the written and physical ability parts of the exam, the interview often accounts for up to 100% of a candidate's overall score. Lepore has proctored hundreds of entry-level and promotional interviews. He shares his unique ability to see the interview through the eyes of the rater. This book is presented in a question-answer format. It provides the candidate with a strong foundation on how to answer over 100 of the questions most commonly asked by fire departments across the country, and provides the rationale as to why the answer is correct. Answers to common situational questions deal with: moral issues, legal issues, violations of policies and procedures, ethical dilemmas, societal obligations, interpersonal conflicts. This updated book includes additional questions and answers.




Norman Hall's Firefighter Exam Preparation Book


Book Description

Guaranteed Top Scores on Your Firefighter's Exam! Want to be a firefighter? Do you know what is involved in taking the exam? Don't take a chance at failing a test you could ace--learn from the expert, Norman Hall. For more than a decade, Norman Hall's Firefighter Exam Preparation Book has been the #1 test preparation book for prospective firefighters. Back by popular demand, Norman Hall has completely updated and revised this hugely successful book for this second edition, presenting new tips and time-tested methods for attaining the highest scores. Practice your skills using features such as tips on how to pass the physical requirements, practice exams with answer keys, memory aids to help you master the recall test, tables for self-scoring, insights on what a career in firefighting entails, and a discussion of the final interview. Use Norman Hall's Firefighter Exam Preparation Book, 2nd Edition to study hard and score at the top!




Dangerous Instincts


Book Description

Fear can't help you in a dangerous situation. A former FBI profiler shows you what can. As one of the world's top experts on psychopathy and criminal behavior, Mary Ellen O'Toole has seen repeatedly how relying on the sense of fear alone often fails to protect us from danger. Whether you are opening the door to a stranger or meeting a date you connected with online, you need to know how to protect yourself from harm-physical, financial, legal, and professional. Using the SMART method, which O'Toole developed and used at the FBI, we can confidently know how to: Respond to a threat in any situation Hire someone who will work inside your home like a contractor or housekeeper Figure out whether a prospective employee is a safe bet Know whom you can trust with your children An especially useful book for women living alone, parents who are concerned about their children's safety, and employers worried about employees who might go postal, Dangerous Instincts gives us the tools used by professionals to navigate potentially hazardous waters. Like The Gift of Fear and The Sociopath Next Door, it will appeal to anyone looking to make the right call in an ever threatening world.




Snoop


Book Description

Does what's on your desk reveal what's on your mind? Do those pictures on your walls tell true tales about you? And is your favorite outfit about to give you away? For the last ten years psychologist Sam Gosling has been studying how people project (and protect) their inner selves. By exploring our private worlds (desks, bedrooms, even our clothes and our cars), he shows not only how we showcase our personalities in unexpected-and unplanned-ways, but also how we create personality in the first place, communicate it others, and interpret the world around us. Gosling, one of the field's most innovative researchers, dispatches teams of scientific snoops to poke around dorm rooms and offices, to see what can be learned about people simply from looking at their stuff. What he has discovered is astonishing: when it comes to the most essential components of our personalities-from friendliness to flexibility-the things we own and the way we arrange them often say more about us than even our most intimate conversations. If you know what to look for, you can figure out how reliable a new boyfriend is by peeking into his medicine cabinet or whether an employee is committed to her job by analyzing her cubicle. Bottom line: The insights we gain can boost our understanding of ourselves and sharpen our perceptions of others. Packed with original research and fascinating stories, Snoop is a captivating guidebook to our not-so-secret lives.




The Senate Intelligence Committee Report on Torture (Academic Edition)


Book Description

The study edition of book the Los Angeles Times called, "The most extensive review of U.S. intelligence-gathering tactics in generations." This is the complete Executive Summary of the Senate Intelligence Committee's investigation into the CIA's interrogation and detention programs -- a.k.a., The Torture Report. Based on over six million pages of secret CIA documents, the report details a covert program of secret prisons, prisoner deaths, interrogation practices, and cooperation with other foreign and domestic agencies, as well as the CIA's efforts to hide the details of the program from the White House, the Department of Justice, the Congress, and the American people. Over five years in the making, it is presented here exactly as redacted and released by the United States government on December 9, 2014, with an introduction by Daniel J. Jones, who led the Senate investigation. This special edition includes: • Large, easy-to-read format. • Almost 3,000 notes formatted as footnotes, exactly as they appeared in the original report. This allows readers to see obscured or clarifying details as they read the main text. • An introduction by Senate staffer Daniel J. Jones who led the investigation and wrote the report for the Senate Intelligence Committee, and a forward by the head of that committee, Senator Dianne Feinstein.




In the Realm of Hungry Ghosts


Book Description

A “thought-provoking and powerful” study that reframes everything you’ve been taught about addiction and recovery—from the New York Times–bestselling author of The Myth of Normal (Bruce Perry, author of The Boy Who Was Raised as a Dog). A world-renowned trauma expert combines real-life stories with cutting-edge research to offer a holistic approach to understanding addiction—its origins, its place in society, and the importance of self-compassion in recovery. Based on Gabor Maté’s two decades of experience as a medical doctor and his groundbreaking work with people with addiction on Vancouver’s skid row, this #1 international bestseller radically re-envisions a much misunderstood condition by taking a compassionate approach to substance abuse and addiction recovery. In the same vein as Bessel van der Kolk’s The Body Keeps the Score, In the Realm of Hungry Ghosts traces the root causes of addiction to childhood trauma and examines the pervasiveness of addiction in society. Dr. Maté presents addiction not as a discrete phenomenon confined to an unfortunate or weak-willed few, but as a continuum that runs throughout—and perhaps underpins—our society. It is not a medical “condition” distinct from the lives it affects but rather the result of a complex interplay among personal history, emotional and neurological development, brain chemistry, and the drugs and behaviors of addiction. Simplifying a wide array of brain and addiction research findings from around the globe, the book avoids glib self-help remedies, instead promoting a thorough and compassionate self-understanding as the first key to healing and wellness. Dr. Maté argues persuasively against contemporary health, social, and criminal justice policies toward addiction and how they perpetuate the War on Drugs. The mix of personal stories—including the author’s candid discussion of his own “high-status” addictive tendencies—and science with positive solutions makes the book equally useful for lay readers and professionals.




Teaching Yoga


Book Description

THE FUNDAMENTALS OF YOGA: Discover the history and philosophy of yoga—plus tools for teaching 108 yoga poses, planning and sequencing your yoga classes, and much more. “Will help [yoga] instructors fine-tune their classroom skills and empower their personal practice.” —Yoga + Joyful Living Drawing on a wide spectrum of perspectives and featuring more than 150 photographs and illustrations, Teaching Yoga covers the fundamental topics of yoga for new and experienced yoga teachers. Inside, you’ll find: • A foundational overview of yoga philosophy and history • Presentations of yoga classics like Vedas; Upanishads; Bhagavad Gita; Yoga Sutras of Patanjali • Profiles of the 11 styles of contemporary yoga, including their history and distinguishing elements • Support and tools for teaching 108 yoga poses, breathing techniques, and meditations • Practical advice for classroom setup, and planning and sequencing yoga classes • Guidance through the process of starting and sustaining a career as a yoga teacher • Over 200 bibliographic sources and a comprehensive index • A useful appendix listing associations, institutes, organizations, and professional resources Addressing 100% of the teacher training curriculum standards set by Yoga Alliance—the world’s leading registry and accreditation source for yoga teachers and schools—Teaching Yoga is the perfect resource for experienced yoga teachers, teachers in training, and anyone interesed in deepening their understanding of their yoga practice.




Confessions of a Necromancer


Book Description

Thirty-five years I've written code, a necromancer weaving spells to bring the dead to life. Hardware and electronics never held any charm for me. I've no love for chips and cables and solder. Give me a keyboard, a screen, and a language, and you have my attention. Thirty-five years produced a lot of work. So I thought, maybe time to talk about some of those projects.