• Database index design and optimization: Some guidelines

    What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.

  • Download SQL Server Insider

    SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database t...

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)

  • SQL Server Data Quality Services makes cleanup a cinch

    SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.

SQL Server Database Modeling and Design

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Microsoft Master Data Services boosts SQL master data management

    With all the excitement around new gadgets in the upcoming release of SQL Server, code-named Denali, it’s easy to forget how much Microsoft played up features in its current version. SQL Server Insider did some digging around in SQL Server 2008 R2 an...  E-Zine

  • database replication

    Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)  Definition

  • multidimensional expressions (MDX)

    multidimensional expressions (MDX)  Definition

  • tablespace

    In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder ...  Definition

  • flat file

    A flat file is a file containing records that have no structured interrelationship.  Definition

  • C++

    C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications.  Definition

  • ActiveX Data Objects (ADO)

    ActiveX Data Objects (ADO) is an application program interface from Microsoft that lets a programmer writing Windows applications get access to a relational or non-relational database from both Microsoft and other database providers.  Definition

  • Database: Glossary

    This is a glossary of database-related terms.  Definition

  • database

    A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued......  Definition

  • data structure

    A data structure is a specialized format for organizing and storing data.  Definition

  • data mart (datamart)

    A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers.  Definition

  • See more Definitions on SQL Server Database Modeling and Design
About SQL Server Database Modeling and Design

A database model is exactly what is sounds like - the structural format of the database. An accurate and up-to-date data model can help SQL Server administrators to create high-performance applications from the get-go and better meet the needs of end users. Common database models include hierarchical, network and relational models. This topic page features the design tips and modeling tools that administrators need to create a successful data model and design an effective database for Microsoft SQL Server.

Back to top