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...
| Autores principales: | , , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 4th ed. 2015. |
| Colección: | The expert's voice in SQL server Pro T-SQL programmer's guide
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629970606719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""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""; ""Context-Sensitive Help""; ""Graphical 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""; ""The Searched CASE Expression""; ""CASE 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""; ""Stored Procedures Best Practices""; ""Stored 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""; ""Hash Indexes""; ""Range Indexes""; ""Natively Compiled Stored Procedures""; ""Chapter 7: Triggers""
- ""DML Triggers""
