Pro T-SQL programmer's guide
Pro T?SQL Programmer?s Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and exist...
| Main Authors: | , , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[Berkeley, CA]
Apress
2015
|
| Edition: | Fourth edition |
| Series: | The expert's voice in SQL server
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- At a Glance; Introduction; Chapter 1: Foundations of T-SQL; A Short History of T-SQL; Imperative vs. Declarative Languages; SQL Basics; Statements; Databases; Transaction Logs; Schemas; Tables; Views; Indexes; Stored Procedures; User-Defined Functions; SQL CLR Assemblies; Elements of Style; Whitespace; Naming Conventions; One Entry, One Exit; Defensive Coding; The SELECT * Statement; Variable Initialization; Summary; Chapter 2: Tools of the Trade; SQL Server Management Studio; IntelliSense; Code Snippets; Keyboard Shortcut Schemes; T-SQL Debugging; SSMS Editing Options
- Hash IndexesRange Indexes; Natively Compiled Stored Procedures; Chapter 7: Triggers; DML Triggers; Multiple Triggers; When to Use DML Triggers; Inserted and Deleted Virtual Tables; Auditing with DML Triggers; Using Change Data Capture Instead; Sharing Data with Triggers; Nested and Recursive Triggers; The UPDATE() and COLUMNS_UPDATED() Functions; Triggers on Views; DDL Triggers; DDL Event Types and Event Groups; Logon Triggers; Summary; Chapter 8: Encryption; The Encryption Hierarchy; Service Master Keys; Database Master Keys; Certificates; Asymmetric Keys; Asymmetric Key "Backups."
- Stored Procedures Best PracticesStored Procedure Example; Recursion in Stored Procedures; Table-Valued Parameters; Temporary Stored Procedures; Recompilation and Caching; Stored Procedure Statistics; Parameter Sniffing; Recompilation; Summary; Chapter 6: In-Memory Programming; The Drivers for In-Memory Technology; Hardware Trends; Getting Started with In-Memory Objects; Step 1: Add a New Memory-Optimized Data FILEGROUP; Step 2: Add a New Memory-Optimized Container; Step 3: Create Your New Memory-Optimized Table; Limitations on Memory-Optimized Tables; In-Memory OLTP Table Indexes
- The Searched CASE ExpressionCASE and Pivot Tables; The IIF Statement; CHOOSE; COALESCE and NULLIF; Cursors; Summary; Chapter 4: User-Defined Functions; Scalar Functions; Recursion in Scalar User-Defined Functions; Procedural Code in User-Defined Functions; Multistatement Table-Valued Functions; Inline Table-Valued Functions; Restrictions on User-Defined Functions; Nondeterministic Functions; State of the Database; Summary; Chapter 5: Stored Procedures; Introducing Stored Procedures; Metadata Discovery; Natively Compiled Stored Procedures; Managing Stored Procedures
- Context-Sensitive HelpGraphical Query Execution Plans; Project-Management Features; The Object Explorer; The SQLCMD Utility; SQL Server Data Tools; SQL Profiler; Extended Events; SQL Server Integration Services; The Bulk Copy Program; SQL Server 2014 Books Online; The AdventureWorks Sample Database; Summary; Chapter 3: Procedural Code; Three-Valued Logic; Control-of-Flow Statements; The BEGIN and END Keywords; The IF ... ELSE Statement; The WHILE, BREAK, and CONTINUE Statements; The GOTO Statement; The WAITFOR Statement; The RETURN Statement; The CASE Expression; The Simple CASE Expression