SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012
You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference.
Why Buy this Book
We often learn good practices from the people that come before us. Sometimes we later learn why those practices make sense. But there are so many exceptions to these rules. Instead of memorizing the exceptions you can learn the techniques of what is really going on with SQL performance and storage. It’s actually a few simple parts that you can test.
Most of the exercises in this book are designed around proper database practices in the workplace. The workplace also offers common challenges and process changes over time. For example, it is good practice to use numeric data for IDs. If you have ever seen a Canadian postal code (zip code), you see the need for character data in relational information. You will occasionally see an off-the-beaten-path strategy demonstrated so you know how to approach a topic in a job interview or workplace assignment.
Chapter 1. Table Data Actions
Chapter 2. Database Schemas and Synonyms
Chapter 3. Data Type Usage
Chapter 4. Special Data Type Options
Chapter 5. Spatial Data Types
Chapter 6. Spatial Aggregates
Chapter 7. Creating Indexes
Chapter 8. Creating Indexes with Code
Chapter 9. Index Analysis
Chapter 10. The GUID Data Type
Chapter 11. Transactions and Locking
Chapter 12. Isolation Levels and Concurrency
Chapter 13. Summary SQL Queries Volume 3