Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008-one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Di...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627662206719 |
Tabla de Contenidos:
- Microsoft® SQL Server® 2008 Step by Step; Introduction; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Other Features; System Requirements; Sample Databases; Practice Files; Using the Practice Files; Uninstalling the Practice Files; Find Additional Content Online; Support for This Book; I. Getting Started with Microsoft SQL Server 2008; Security Subsystem; Programming Interfaces; Service Broker; SQL Server Agent; Replication; High Availability; The Relational Engine in SQL Server 2008; Business Intelligence; Reporting Services
- Analysis ServicesChapter 1 Quick Reference; 2. Installing and Configuring SQL Server 2008; Infrastructure Requirements; Service Accounts; Collation Sequences; Authentication Modes; SQL Server Instances; Upgrading to SQL Server 2008; Side-by-Side Upgrade; Installing SQL Server 2008; Chapter 2 Quick Reference; 3. Using the Tools in SQL Server 2008; Management Tools in SQL Server 2008; SQL Server Management Studio; Database Mail; Performance Management Tools; Database Engine Tuning Advisor; Performance Studio; Business Intelligence Tools; Chapter 3 Quick Reference; II. Designing Databases
- SQL Server Database StructureFilegroups; Creating a Database; Moving Databases; Attaching a Database; Chapter 4 Quick Reference; 5. Designing Tables; Schemas; Data Types; Decimal Data Types; Character Data; Unicode Data; Varchar(max) and nvarchar(max); Date and Time Data; Binary Data; XML; FILESTREAM Data; Spatial Data Type; HierarchyID Data Type; Column Properties; Creating Tables; Computed Columns; Sparse Columns; Constraints; Unique Constraints; Check Constraints; Default Constraints; Foreign Keys; Database Diagrams; Chapter 5 Quick Reference; 6. Indexes; Index levels; Clustered Indexes
- Nonclustered IndexesIncluded Columns; Filtered Indexes; Online Index Creation; Index Management and Maintenance; Fill Factor; Defragmenting an Index; Disabling an index; XML Indexes; Spatial Indexes; Chapter 6 Quick Reference; 7. Partitioning; Partition Schemes; Partitioning Tables and Indexes; Creating a Partitioned Index; Managing Partitions; Altering a Partition Scheme; Index Alignment; SWITCH Operator; Chapter 7 Quick Reference; III. Retrieving and Manipulating Data; Sorting Results; Filtering Data; Retrieving from More Than One Table; Retrieving Unique Results; Chapter 8 Quick Reference
- 9. Advanced Data RetrievalAggregating Data; Filtering Aggregates; Running Aggregates; Calculating Pivot Tables; Ranking Data; Aggregating Result Sets; Common Table Expressions; Querying XML Data; Chapter 9 Quick Reference; 10. Data Manipulation; SELECT INTO; Updating Data; Deleting Data; MERGE Statement; OUTPUT Clause; Transaction Handling; Tracking Changes; Change Data Capture; Chapter 10 Quick Reference; IV. Designing Advanced Database Objects; Modifying Data Through a View; Creating an Indexed View; Chapter 11 Quick Reference; 12. Stored Procedures; Commenting Code
- Variables, Parameters, and Return Codes
