SQL Server 2012 Data Design and Retrieval (Volume 0)

What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isn't the book for you. If you want to really learn SQL Server and be able to apply it to your job, you've found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasn't enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20+ pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150+ page dissertation on SQL Server indexes. You'll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require.

你需要完成工作所需的一切。這是暢銷 SQL Server 作者 Mike Hotek 的最新著作。《SQL Server 2012 資料設計與檢索》是您建立資料庫和查詢資料的參考書。我不再受到出版商的限制，可以涵蓋所有高級主題。如果您曾經購買過我的書，並且很快發現自己已經超越了書中的內容，那麼這本書會有很大不同。無論您是初學者還是資深的 SQL Server 專業人士，這本書都會對您的資料庫設計和資料管理方式產生影響。這是我有史以來撰寫的關於 SQL Server 最深入的一本書。本書從基礎知識開始，逐步深入介紹高級細節，提供您在解決資料庫專業人士每天面臨的現實問題時可以使用的參考資料。每個主題都通過來自真實客戶實施的詳細練習來加強。所有內容都已更新至 SQL Server 2012 SP1，並包括引入的新功能。每個主題都從基礎知識開始，為初學者提供良好的起點，然後深入探討對資深的 SQL Server 專業人士也感興趣的高級細節。本書還是準備參加 70-461《查詢 Microsoft SQL Server 2012》認證考試的絕佳起點。我相信通過學習工作所需的知識並使用考試驗證掌握程度。如果您只是尋找一本通過考試的食譜，那麼這本書不適合您。如果您想真正學習 SQL Server 並能夠應用於工作，那麼您找到了正確的書。我們從簡要介紹 SQL Server 開始，並引導您完成安裝所需的一切。安裝完成後，我們將介紹資料庫的結構，包括 FILESTREAM 儲存和 SQL Server 2012 中的運作方式的詳細資訊。在完成先決條件後，第 5 章成為設計、操作和查詢資料的起點。您將獲得對所有資料類型的詳細討論，特別是何時以及如何使用它們，並通過示例展示為什麼 FLOAT 實際上比 DECIMAL 更準確。Mike 還解釋了如何真正設計資料庫，而不需要糾結於令人困惑的技術術語。一旦我們有了一些表格，我們將深入探討磁碟上的儲存機制，實際存儲行的方式，以及如何計算實際的空間消耗。您將學習所有操作資料的技巧，包括如何操作層次結構中的樹和子樹。並發性章節提供了有關交易管理的深入視圖。如果這還不夠，我們將帶您進行基本、中級和高級查詢，應用 SELECT 語句的所有可能操作，包括超過 20 頁的窗口函數和查詢 XML，最後深入探討空間資料。在找出如何撰寫 SELECT 語句以查找最近的星巴克之後，我們以超過 150 頁的論文結束了 SQL Server 索引的介紹。您將深入了解每種類型索引的每個組件，包括解釋統計資料實際上是如何建立的，並提供一些示例，說明統計資料對查詢計劃可能產生完全意外的影響。本書不僅介紹了分區，還提供了一個實際的實現，很少有資料庫管理員知道如何執行，同時解釋了一個像欄位的可為空性這樣簡單的事情如何導致您的查詢需要加倍的處理器週期。