Professional Microsoft SQL server 2008 programming

Professional Microsoft SQL server 2008 programming / Rob Vieira.

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming . Review the new features of SQL Server that will be of interest to you as an experi.

Saved in:
Bibliographic Details
Main Author: Vieira, Robert
Format: eBook
Language:English
Published: Indianapolis, Ind. : Wiley Pub., ©2009.
Series:Wrox professional guides.
Subjects:
SQL server.
SQL server
Client/server computing.
Database management.
COMPUTERS > Data Processing.
Client/server computing
Database management
Online Access:Click for online access
Table of Contents:
  • Cover
  • Contents
  • Introduction
  • Chapter 1: Being Objective
  • So, What Exactly Do We Have Here?
  • An Overview of Database Objects
  • SQL Server Data Types
  • SQL Server Identifiers for Objects
  • Summary
  • Chapter 2: Tool Time
  • Books Online
  • The SQL Server Configuration Manager
  • The SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio
  • SQL Server Integration Services (SSIS)
  • Reporting Services
  • Bulk Copy Program (bcp)
  • SQL Server Profiler
  • sqlcmd
  • Summary
  • Chapter 3: Asking a Better Question
  • A Quick Review of Subqueries
  • Building a Nested Subquery
  • Correlated Subqueries
  • Derived Tables
  • The EXISTS Operator
  • The INTERSECT and EXCEPT Operators
  • Common Table Expressions (CTEs)
  • Recursive Queries
  • MERGE
  • Using External Calls to Perform Complex Actions
  • Performance Considerations
  • Summary
  • Chapter 4: XML Integration
  • The XML Data Type
  • Retrieving Relational Data in XML Format
  • A Quick Heads Up Regarding XML Indexes
  • A Brief Word on Hierarchical Data
  • Summary
  • Chapter 5: Daring to Design
  • Normalization 201
  • Relationships
  • Diagramming
  • Logical versus Physical Design
  • Dealing with File-Based Information Via Classic BLOBs
  • Subcategories
  • Database Reuse
  • De-Normalization
  • Partitioning for Scalability
  • The SQL Server Diagramming Tools
  • Regarding Date Columns
  • Summary
  • Chapter 6: Core Storage and Index Structure
  • SQL Server Storage
  • Understanding Indexes
  • Creating, Altering, and Dropping Indexes
  • Choosing Wisely: Deciding What Index Goes Where and When
  • Maintaining Your Indexes
  • Summary
  • Chapter 7: More Advanced Index Structures
  • XML Indexes
  • User-Defined Data Types
  • Hierarchical Data
  • Spatial Data
  • Filestreams
  • Enabling Filestreaming
  • Table Compression
  • Summary
  • Chapter 8: Views
  • Reviewing View Syntax
  • More Complex Views
  • Editing Views with T-SQL
  • Dropping Views
  • Auditing: Displaying Existing Code
  • Protecting Code: Encrypting Views
  • About Schema Binding
  • Making Your View Look Like a Table with VIEW_METADATA
  • Indexed (Materialized) Views
  • Partitioned Views
  • Summary
  • Chapter 9: Scripts and Batches
  • Script Basics
  • Batches
  • SQLCMD
  • Dynamic SQL: Generating Your Code on the Fly with the EXEC Command
  • Control-of-Flow Statements
  • Summary
  • Chapter 10: Advanced Programmability
  • A More Advanced Look At Stored Procedures
  • Table-Valued Parameters (TVPs)
  • Debugging
  • Understanding the SQLCLR and .NET Programming in SQL Server
  • Creating Aggregate Functions
  • Custom Data Types
  • Summary
  • Chapter 11: Transactions and Locks
  • Transactions
  • How the SQL Server Log Works
  • Locks and Concurrency
  • Setting the Isolation Level
  • Dealing with Deadlocks (a.k.a. 8220;A 12058221;)
  • Summary
  • Chapter 12: Triggers
  • What Is a Trigger?
  • Using Triggers for Data Integrity Rules
  • Other Common Uses for Triggers
  • Other Trigger Issues
  • INSTEAD OF Triggers
  • IF UPDATE() and COLUMNS_UPDATED()
  • Performance Considerations
  • Dropping Triggers
  • Summary
  • Chap.

Similar Items