View Larger Image	Ken Henderson Addison-Wesley, Published October 2004, ISBN 0321287509
	List Price: $139.99 Our Price: $87.50 You Save: $52.49 (37% Off)
	Availability: Out-Of-Stock

People who purchase this book frequently purchase:

• SQL Server Query Performance Tuning Distilled, 2nd Edition; Sajal Dam, $30.50, 39% Off!
• MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, 2nd Edition; Microsoft Corp., $37.50, 37% Off!
• MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, 2nd Edition; Microsoft Corp., $37.50, 37% Off!
• Microsoft SQL Server 2000 Unleashed; Ray Rankins, et al, $44.50, 36% Off!

• Databases : Microsoft SQL Server
• Databases : SQL

• Addison-Wesley

Ken Henderson's three guides to SQL Server have been widely praised by readers and reviewers alike. Now all three of them are available in an attractive, sturdy, specially priced boxed set. The three books included are The Guru's Guide to Transact-SQL, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML, and The Guru's Guide to SQL Server Architecture and Internals. This set is an invaluable reference for SQL Server administrators and developers of all levels.

About the Author

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.

The three books included are:

• Guru's Guide to Transact-SQL

  Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.

  Table of Contents

  Foreword xvi

  Preface xvii

  About the Sample Databases xviii
  Results Abridged xviii
  On Formality xviii
  Acknowledgments xix

  Chapter 1: Introductory Transact-SQL 1

  Choosing a SQL Editor 2
  Creating a Database 3
  Creating Tables 3
  Inserting Data 5
  Updating Data 6
  Deleting Data 7
  Querying Data 7
  Filtering Data 11
  Grouping Data 18
  Ordering Data 19
  Column Aliases 20
  Table Aliases 21
  Managing Transactions 21
  Summary 22

  Chapter 2: Transact-SQL Data Type Nuances 23

  Dates 23
  Strings 34
  Numerics 54
  BLOBs 59
  Bits 66
  UNIQUEIDENTIFIER 67
  Cursor Variables 68
  Timestamps 73
  Summary 75

  Chapter 3: Missing Values 77

  NULL and Expressions 78
  NULL and Functions 78
  NULL and ANSI SQL 79
  NULL and Stored Procedures 81
  NULL If You Must 83

  Chapter 4: DDL Insights 85

  CREATE TABLE 86
  Dropping Objects 89
  CREATE INDEX 90
  TEMPORARY OBJECTS 91
  Object Naming and Dependencies 93
  Summary 95

  Chapter 5: DML Insights 97

  INSERT 97
  UPDATE 107
  DELETE 114
  Detecting DML Errors 118
  Summary 118

  Chapter 6: The Mighty SELECT Statement 119

  Simple SELECTs 119
  Computational and Derived Fields 120
  SELECT TOP 121
  Derived Tables 122
  Joins 126
  Predicates 128
  Subqueries 140
  Aggregate Functions 147
  GROUP BY and HAVING 150
  UNION 157
  ORDER BY 159
  Summary 161

  Chapter 7: Views 163

  Restrictions 163
  ANSI SQL Schema VIEWs 165
  Getting a VIEW's Source Code 166
  Updatable VIEWs 166
  WITH CHECK OPTION 167
  Derived Tables 167
  Dynamic VIEWs 168
  Partitioning Data Using Views 170
  Summary 172

  Chapter 8: Statistical Functions 173

  The Case for CASE 174
  Efficiency Concerns 176
  Variance and Standard Deviation 176
  Medians 177
  Clipping 185
  Returning the Top n Rows 186
  Rankings 190
  Modes 193
  Histograms 193
  Cumulative and Sliding Aggregates 195
  Extremes 197
  Summary 199

  Chapter 9: Runs and Sequences 201

  Sequences 201
  Runs 207
  Intervals 210
  Summary 212

  Chapter 10: Arrays 213

  Arrays as Big Strings 213
  Arrays as Tables 220
  Summary 228

  Chapter 11: Sets 229

  Unions 230
  Differences 231
  Intersections 234
  Subsets 235
  Summary 239

  Chapter 12: Hierarchies 241

  Simple Hierarchies 241
  Multilevel Hierarchies 242
  Indented Lists 249
  Summary 250

  Chapter 13: Cursors 251

  On Cursors and ISAMs 251
  Types of Cursors 253
  Appropriate Cursor Use 258
  T-SQL Cursor Syntax 263
  Cofiguring Cursors 272
  Updating Cursors 276
  Cursor Variables 277
  Cursor Stored Procedures 279
  Optimizing Cursor Performance 279
  Summary 281

  Chapter 14: Transactions 283

  Transactions Defined 283
  How SQL Server Transactions Work 284
  Types of Transactions 285
  Avoiding Transactions Altogether 287
  Automatic Transaction Management 288
  Transaction Isolation Levels 289
  Transaction Commands and Syntax 293
  Debugging Transactions 299
  Optimizing Transactional Code 300
  Summary 301

  Chapter 15: Stored Procedures and Triggers 303

  Stored Procedure Advantages 304
  Internals 305
  Creating Stored Procedures 307
  Executing Stored Procedures 316
  Environmental Concerns 317
  Parameters 320
  Important Automatic Variables 323
  Flow Control Language 324
  Errors 325
  Nesting 328
  Recursion 328
  Autostart Procedures 330
  Encryption 330
  Triggers 330
  Debugging Procedures 334
  Summary 335

  Chapter 16: Transact-SQL Performance Tuning 337

  General Performance Guidelines 337
  Database Design Performance Tips 338
  Index Performance Tips 340
  SELECT Performance Tips 342
  INSERT Performance Tips 344
  Bulk Copy Performance Tips 344
  DELETE and UPDATE Performance Tips 346
  Cursor Performance Tips 346
  Stored Procedure Performance Tips 347
  SARGs 351
  Denormalization 368
  The Query Optimizer 384
  The Index Tuning Wizard 394
  Profiler 396
  Perfmon 397
  Summary 399

  Chapter 17: Administrative Transact-SQL 401

  GUI Administration 401
  System Stored Procedures 402
  Administrative Transact-SQL Commands 402
  Administrative System Functions 402
  Administrative Automatic Variables 402
  Where's the Beef? 404
  Summary 461

  Chapter 18: Full-Text Search 463

  Full-Text Predicates 468
  Rowset Functions 471
  Summary 474

  Chapter 19: OLE Automation 475

  sp_exporttable 476
  sp_importtable 480
  sp_getSQLregistry 484
  Summary 486

  Chapter 20: Undocumented T-SQL 487

  Defining Undocumented 487
  Undocumented DBCC Commands 488
  Undocumented Functions and Variables 499
  Undocumented Trace Flags 502
  Undocumented Procedures 503
  Summary 509

  Chapter 21: Potpourri 511

  Obscure Functions 511
  Data Scrubbing 521
  Iteration Tables 525
  Summary 526

  Appendix: Suggested Resources 527

  Books 527
  Internet Resources 528

  Index 529

  
  

• Guru's Guide to SQL Server Stored Procedures, XML, and HTML

  More than just a catalog of coding tricks and syntax subtleties, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to Transact-SQL, this book teaches that stored procedure development does not occur in a vacuum--it involves a wide variety of skills, subjects, and technologies--and helps the reader become a better software engineer, not just a stored procedure expert. Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing to advanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming. The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code.

  
  

  Table of Contents

  Preface.
  Introduction.
  

  I. THE BASICS.

  1. Stored Procedure Primer.
  2. Suggested Conventions.
  3. Common Design Patterns.
  4. Source Code Management.
  5. Database Design.
  6. Data Volumes.
  

  II. OBJECTS.

  7. Error Handling.
  8. Triggers.
  9. Views.
  10. User-Defined Functions.
  

  III. HTML, XML, AND .NET.

  11. HTML.
  12. Introduction to XML.
  13. XML and SQL Server: HTTP Queries.
  14. XML and SQL Server: Retrieving Data.
  15. XML and SQL Server: OPENXML.
  16. Introduction to .NET.
  

  IV. ADVANCED TOPICS.

  17. Performance Considerations.
  18. Debugging and Profiling.
  19. Automation.
  20. Extended Stored Procedures.
  21. Administrative Stored Procedures.
  22. Undocumented Code.
  23. Arrays.
  

  V. ESSAYS ON SOFTWARE ENGINEERING.

  24. Create a Workable Environment.
  25. Make Small Changes.
  26. Test Your Work.
  Index.

  
  

• Guru's Guide to SQL Server Architecture And Internals

  "In my two previous SQL Server books, I focused more on the pragmatic aspects of SQL Server--how to program it and how to make practical use of its many features. As the title suggests, this book focuses more on the architectural design of the product. Here, we dwell on the technical underpinnings of the product more than on how to use it. It's my belief that understanding how the product works will make you a better SQL Server practitioner. You will use the product better and leverage its many features more successfully in your work because you will have a deeper understanding of how those features work and how they were intended to be used."
  -Author Ken Henderson

  
  

  Tabel of Contents

  List of Exercises.
  
  
  Foreword.
  
  
  Historical Perspective.
  
  
  Preface.
  
  
  Acknowledgments.
  
  
  Introduction.
  
  
  About the Author.
  

  I. FOUNDATIONS.

  1. Overview.
  
  
  Chapter Overview.
  Chapter Pairs.
  About the Code.
  2. Windows Fundamentals.
  
  
  The Win32 API.
  User Mode vs. Kernel Mode.
  Processes and Threads.
  Virtual Memory vs. Physical Memory.
  Subsystems.
  Dynamic-Link Libraries.
  Tools.
  Recap.
  Knowledge Measure.
  3. Processes and Threads.
  
  
  Processes.
  Threads.
  Thread Scheduling.
  Thread Synchronization.
  4. Memory Fundamentals.
  
  
  Memory Basics.
  Virtual Memory.
  Heaps.
  Shared Memory.
  5. I/O Fundamentals.
  
  
  I/O Basics.
  Asynchronous and Nonbuffered I/O.
  Scatter-Gather I/O.
  I/O Completion Ports.
  Memory-Mapped File I/O.
  6. Networking Fundamentals.
  
  
  Overview.
  Named Pipes.
  Windows Sockets.
  Remote Procedure Call.
  Recap.
  Knowledge Measure.
  7. COM.
  
  
  Overview.
  Before COM.
  The Dawn of COM.
  Basic Architecture.
  COM at Work.
  Threading Models.
  COM and SQL Server.
  Recap.
  Knowledge Measure.
  8. XML.
  
  
  Overview.
  Simplicity Comes at a Price.
  A Brief History of XML.
  XML vs. HTML: An Example.
  Document Type Definitions.
  XML Schemas.
  Converting XML to HTML Using a Style Sheet.
  The Document Object Model.
  Processing XML with MSXML.
  Resources.
  Recap.
  Knowledge Measure.

  II. SUBSYSTEMS, COMPONENTS, AND TECHNOLOGIES.

  9. SQL Server as a Server.
  
  
  SQL Server and Networking.
  The SQL Server Executable.
  SQL Server's DLLs.
  SQL Server I/O.
  SQL Server Components.
  Recap.
  Knowledge Measure.
  10. User Mode Scheduler.
  
  
  UMS Design Goals.
  User Mode vs. Kernel Mode Scheduling.
  Preemptive vs. Cooperative Tasking.
  How UMS Takes Over Scheduling.
  The UMS Scheduler.
  The UMS Scheduler Lists.
  Going Preemptive.
  Hidden Schedulers.
  DBCC SQLPERF(umsstats).
  Recap.
  Knowledge Measure.
  11. SQL Server Memory Management.
  
  
  Memory Regions.
  Sizing.
  The BPool.
  Primitive Allocations.
  AWE.
  The Lazywriter.
  The Memory Managers.
  Pulling It All Together.
  Recap.
  Knowledge Measure.
  12. Query Processor.
  
  
  Key Terms and Concepts.
  Parsing.
  Optimization Stages.
  Optimization Limits.
  Parameter Sniffing.
  Auto-Parameterization.
  Indexing.
  Statistics.
  Indexable Expressions.
  Join Order and Type Selection.
  Logical and Physical Operators.
  Recap.
  Knowledge Measure.
  13. Transactions.
  
  
  The ACID Test.
  How SQL Server Transactions Work.
  Types of Transactions.
  Avoiding Transactions Altogether.
  Automatic Transaction Management.
  Transaction Isolation Levels.
  Transaction Commands and Syntax.
  Debugging Transactions.
  Optimizing Transactional Code.
  Recap.
  Knowledge Measure.
  14. Cursors.
  
  
  Overview.
  On Cursors and ISAM Databases.
  Types of Cursors.
  Appropriate Cursor Use.
  Transact-SQL Cursor Syntax.
  Configuring Cursors.
  Updating Cursors.
  Cursor Variables.
  Cursor Stored Procedures.
  Optimizing Cursor Performance.
  Recap.
  Knowledge Measure.
  15. ODSOLE.
  
  
  Overview.
  The sp_OA Procedures.
  Automating with ODSOLE.
  Automating SQL-DMO by Using ODSOLE.
  Using ODSOLE to Automate Custom Objects.
  Recap.
  Knowledge Measure.
  16. Full-Text Search.
  
  
  Overview.
  Architectural Details.
  Setting Up Full-Text Indexes.
  Full-Text Predicates.
  Rowset Functions.
  Recap.
  Knowledge Measure.

  III. DATA SERVICES.

  17. Server Federations.
  
  
  Partitioned Views.
  Recap.
  Knowledge Measure.
  18. SQLXML.
  
  
  Overview.
  MSXML.
  FOR XML.
  Using FOR XML.
  OPENXML.
  Using OPENXML.
  Accessing SQL Server over HTTP.
  URL Queries.
  Using URL Queries.
  Template Queries.
  Mapping Schemas.
  Updategrams.
  XML Bulk Load.
  Managed Classes.
  SQLXML Web Service (SOAP) Support.
  SQLXML Limitations.
  Recap. Knowledge Measure.
  19. Notification Services.
  
  
  How It Works.
  Building Your Own Notification Application.
  Recap.
  Knowledge Measure.
  20. Data Transformation Services.
  
  
  Overview.
  Packages.
  The Multiphase Data Pump.
  The Bulk Insert Task.
  The Data Driven Query Task.
  ActiveX Transformations.
  Other Types of Transformations.
  Lookup Queries.
  Workflow Properties.
  DTS and Transactions.
  Controlling Package Workflow through Scripting.
  Parameterized DTS Packages.
  The DSO Rowset Provider.
  Using DTS to Transform Replication Subscriptions.
  Custom Tasks.
  Controlling DTS through Automation.
  Recap.
  Knowledge Measure.
  21. Snapshot Replication.
  
  
  Overview.
  The Snapshot Agent.
  Duties of the Snapshot and Distribution Agents.
  Updatable Subscriptions.
  Remote Agent Activation.
  Replication Cleanup.
  Recap.
  Knowledge Measure.
  22. Transactional Replication.
  
  
  Overview.
  The MSrepl_commands Table.
  The sp_replcmds Procedure.
  The sp_repldone Procedure.
  Update Stored Procedures.
  Concurrent Snapshot Processing.
  Updatable Subscriptions.
  Validating Replicated Data.
  Skipping Errors.
  Cleanup.
  Recap.
  Knowledge Measure.
  23. Merge Replication.
  
  
  Overview.
  Conflict Resolution.
  Generations.
  Filtering.
  Identity Range Management.
  Recap.
  Knowledge Measure.

  IV. UNDOCUMENTED SQL SERVER.

  24. Finding Undocumented Features.
  
  
  The syscomments Gold Mine.
  Goodies in sysobjects.
  Scripting Undocumented and System Objects.
  The Profiler Treasure Trove.
  Snooping around in the Installation Scripts.
  DLL Imports.
  Recap.
  Knowledge Measure.
  25. DTSDIAG.
  
  

  V. ESSAYS.

  Why I Really, Really Don't Like Fish!
  
  
  Pseudo-Techie Tactics 101.
  
  
  Index.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account