SQL Server 2008 Transact-SQL Recipes
The purpose of this book is to quickly provide you with the skills you need to solve problems and perform tasks using the Transact-SQL language. I wrote this book in a problem/solution format in order to establish an immediate understanding of a task and its associated Transact-SQL solution. You can...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2013
|
| Những chủ đề: | |
| Truy cập trực tuyến: | https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34786 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-34786 |
|---|---|
| record_format |
dspace |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
SQL Computer |
| spellingShingle |
SQL Computer Sack, Joseph SQL Server 2008 Transact-SQL Recipes |
| description |
The purpose of this book is to quickly provide you with the skills you need to solve problems and perform tasks using the Transact-SQL language. I wrote this book in a problem/solution format in order to establish an immediate understanding of a task and its associated Transact-SQL solution. You can use this book to look up the task you want to perform, read how to do it, and then perform the task on your own system. While writing this book, I followed a few key tenets:
• Keep it brief, providing just enough information needed to get the job done.
• Allow recipes and chapters to stand alone—keeping cross-references and distractions to a tolerable minimum.
• Focus on features that are typically implemented entirely using Transact-SQL. For example, I cover the new Resource Governor feature because it will typically be deployed by DBAs using Transact-SQL—whereas I do not cover Policy-Based Management due to its underlying dependencies on SQL Server Agent, SQL Server Management Objects (SMO), and SQL Server Management Studio. Fortunately, most of the new SQL Server engine improvements are entirely Transact-SQL based, and therefore are included in this book.
• Write recipes that help a range of skill sets, from novice to professional. I begin each chapter with basic recipes and progressively work up to more advanced topics. Regarding new SQL Server 2008 features, I have interwoven them throughout the book in the chapters where they apply. If you are just looking for a refresh on new Transact-SQL features, I specifically call them out at the beginning of each chapter in which they exist. Although a key tenet of this book is to keep things brief, you’ll notice that this book is still quite
large. This is a consequence of the continually expanding SQL Server feature set; however, rest assured that the recipes contained within are still succinct and constructed in such a way as to quickly give you the answers you need to get the job done.
I’ve written this book for SQL Server developers, administrators, application developers, and IT generalists who are tasked with developing databases or administering a SQL Server environment.
You can read this book from start to finish or jump around to topics that interest you. You can use this book to brush up on topics before a job interview or an exam. Even for the more experienced SQL Server professionals, memory fades—and this book can help quickly refresh your memory on
the usage of a command or technique.
Thanks for reading! |
| format |
Book |
| author |
Sack, Joseph |
| author_facet |
Sack, Joseph |
| author_sort |
Sack, Joseph |
| title |
SQL Server 2008 Transact-SQL Recipes |
| title_short |
SQL Server 2008 Transact-SQL Recipes |
| title_full |
SQL Server 2008 Transact-SQL Recipes |
| title_fullStr |
SQL Server 2008 Transact-SQL Recipes |
| title_full_unstemmed |
SQL Server 2008 Transact-SQL Recipes |
| title_sort |
sql server 2008 transact-sql recipes |
| publisher |
Apress |
| publishDate |
2013 |
| url |
https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34786 |
| _version_ |
1819833020337618944 |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-347862014-01-20T01:40:25Z SQL Server 2008 Transact-SQL Recipes Sack, Joseph SQL Computer The purpose of this book is to quickly provide you with the skills you need to solve problems and perform tasks using the Transact-SQL language. I wrote this book in a problem/solution format in order to establish an immediate understanding of a task and its associated Transact-SQL solution. You can use this book to look up the task you want to perform, read how to do it, and then perform the task on your own system. While writing this book, I followed a few key tenets: • Keep it brief, providing just enough information needed to get the job done. • Allow recipes and chapters to stand alone—keeping cross-references and distractions to a tolerable minimum. • Focus on features that are typically implemented entirely using Transact-SQL. For example, I cover the new Resource Governor feature because it will typically be deployed by DBAs using Transact-SQL—whereas I do not cover Policy-Based Management due to its underlying dependencies on SQL Server Agent, SQL Server Management Objects (SMO), and SQL Server Management Studio. Fortunately, most of the new SQL Server engine improvements are entirely Transact-SQL based, and therefore are included in this book. • Write recipes that help a range of skill sets, from novice to professional. I begin each chapter with basic recipes and progressively work up to more advanced topics. Regarding new SQL Server 2008 features, I have interwoven them throughout the book in the chapters where they apply. If you are just looking for a refresh on new Transact-SQL features, I specifically call them out at the beginning of each chapter in which they exist. Although a key tenet of this book is to keep things brief, you’ll notice that this book is still quite large. This is a consequence of the continually expanding SQL Server feature set; however, rest assured that the recipes contained within are still succinct and constructed in such a way as to quickly give you the answers you need to get the job done. I’ve written this book for SQL Server developers, administrators, application developers, and IT generalists who are tasked with developing databases or administering a SQL Server environment. You can read this book from start to finish or jump around to topics that interest you. You can use this book to brush up on topics before a job interview or an exam. Even for the more experienced SQL Server professionals, memory fades—and this book can help quickly refresh your memory on the usage of a command or technique. Thanks for reading! About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv About the Technical Reviewer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxi nCHAPTER 1 SELECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 nCHAPTER 2 Perform, Capture, and Track Data Modifications . . . . . . . . . . . . . . . . . . . . . 63 nCHAPTER 3 Transactions, Locking, Blocking, and Deadlocking . . . . . . . . . . . . . . . . . . 115 nCHAPTER 4 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 nCHAPTER 5 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197 nCHAPTER 6 Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217 nCHAPTER 7 Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239 nCHAPTER 8 SQL Server Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257 nCHAPTER 9 Conditional Processing, Control-of-Flow, and Cursors . . . . . . . . . . . . . . . 307 nCHAPTER 10 Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 325 nCHAPTER 11 User-Defined Functions and Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343 nCHAPTER 12 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373 nCHAPTER 13 CLR Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 401 nCHAPTER 14 XML, Hierarchies, and Spatial Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 419 nCHAPTER 15 Hints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449 nCHAPTER 16 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 nCHAPTER 17 Principals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475 nCHAPTER 18 Securables, Permissions, and Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 501 nCHAPTER 19 Encryption. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547 nCHAPTER 20 Service Broker. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 579 nCHAPTER 21 Configuring and Viewing SQL Server Options . . . . . . . . . . . . . . . . . . . . . . . 615 nCHAPTER 22 Creating and Configuring Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 621 nCHAPTER 23 Database Integrity and Optimization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 669 nCHAPTER 24 Maintaining Database Objects and Object Dependencies . . . . . . . . . . . . 687 nCHAPTER 25 Database Mirroring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 697 nCHAPTER 26 Database Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 717 nCHAPTER 27 Linked Servers and Distributed Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723 nCHAPTER 28 Query Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 739 nCHAPTER 29 Backup and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 789 nINDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 823 2013-07-19T01:33:18Z 2013-07-19T01:33:18Z 2008 Book 978-1-59059-980-8 https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34786 en application/pdf Apress |