You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company's bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues. Even if your system is not in trouble right now, you can use what you will learn in this book to view the history of wait statistics.

As companies grow and do more business, the data they store in databases similarly grows. If you want to be a go-to person on the inner workings of SQL Server, then this book will be your partner in achieving that goal. If you have completed the SQL Queries Joes 2 Pros book you have written some advanced queries. This book builds on that knowledge and will show you more about the parts of SQL Server at work behind the scenes when you are running queries and creating new database objects. Most importantly, you will learn how to make the essential queries for your business run most efficiently and at the fastest speed possible.

Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server's performance. Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance.

Building on the success of Morelan's previous series, this volume will help anyone transform themselves from a beginner "Joe" into a SQL 2012 "Pro."

Information is everywhere. But imagine the CIO of a company who has spent millions implementing databases and applications, yet doesn't know how to view that data in a way to make good decisions that make the company more profitable. That is where you come in. As a database professional you will be asked to provide answers to questions from the CIO and others in the company from that data. If your company is using SQL Server to host some of the company's data, chances are you will use SQL Server Reporting Services to create professional looking reports to hand to the CIO. This book is meant to be a fantastic value that gets you started with SSRS. You will learn with many hands-on exercises that build on skills from chapter to chapter. Each chapter has a "Points to Ponder" section that summarizes the content, and you will also find a short review quiz at the end.

Finally a book for the true SQL Server beginner! Whether you are brand new to data bases and are thinking of getting your 70-461 certification or already a semi-pro working in the field and need some fingertip support, this is this is the book for you. Joes 2 Pros does not assume you already know anything about data bases or SQL server. The Author, Rick Morelan, started out as a true beginner after he decided he had had enough of working on a fishing boat in Alaska. Rick struggled for years to acquire the knowledge necessary just to get his foot in the door. Many years later as an instructor, who was not happy with the instructional material available for his SQL students, he began the process of creating his own material. In 2009 Rick released his first book, "Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners" for SQL 2008. Due to its clear writing style, easy to follow images and free downloadable labs it quickly became a top seller on Amazon. This book builds on the success of the previous series and will help anyone transform themselves from a beginner "Joe" into a SQL 2012 "Pro." For those of you who have read the 2008 series for the 70-433 Exam you will find a lot of the same material from the SQL 2008 book in this SQL 2012 book. This is because much of the 70-461 test covers the same material as the 70-433. I have added material that is new to the test and removed material that is no longer relevant. If you have already read this series or have already passed the 70-433 exam you may choose to read my book which covers only the changes from 70-433 to 70-461 entitled "Joes 2 Pros SQL 2012 Queries 70-461 Exam for SQL 2008 Pros."