Share via

  • Articolo

Architecture and Database Design

Creating an effective database design for your Microsoft SQL Server databases requires an understanding of the business functions you want to model. Effective database design also requires an understanding of the database concepts and features that you want to use to represent those business functions. Make sure that you accurately use database design to model the business, because it can be time-consuming to significantly change the design of a database after you implement it. Using best practices to complete database design results in SQL Server databases that perform better.

An Overview of SQL Server 2005 for the Database Developer An Overview of SQL Server 2005 for the Database Developer

This document provides an overview of new features for database design and development in Microsoft SQL Server 2005.

Articles and Columns

  • Analysis Services 2005 Processing Architecture
    Processing is the operation in which the Analysis server reads data from the relational data source and populates the cubes, dimensions, mining models, etc. This article describes the Analysis Services 2005 processing architecture in detail and provides guidance on how and when to use the various processing controls.

  • Multiple Active Result Sets (MARS) in SQL Server 2005

    Understand the database design, architecture, and semantic improvements that MARS offers in SQL Server 2005, and learn the ways in which your applications may benefit from these changes.

  • Partitioned Tables and Indexes in SQL Server 2005
    Find out why, when, and how to use SQL Server 2005 table-based partitioning features to improve the manageability and performance of your large tables.

Webcasts

Resources in the SQL Server Books Online

My Learning

More...