Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Database Design, Basics Rss

   Items 1 to 20 of 33    Older >>
 

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,876 reads

Views and Horizontal Partitioning

Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.   Read more...
By Jambu Krishnamurthy 2007/04/12 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,836 reads

A Relational Model of Data for Large Shared Data Banks

The classic paper from Dr. Codd.  Read more...
By Additional Articles 2007/06/25 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 3,137 reads

Views and Horizontal Partitioning

Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.   Read more...
By Jambu Krishnamurthy 2007/04/12 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,836 reads

Techniques for Uniquely Identifying Database Records

When designing and creating a data model for a data-driven application, the records in tables must each be uniquely identifiable. By having a unique value associated with each record, individual records can be selected, updated, or deleted. Being able to uniquely identify records is so important and standard in a database system that databases allow those designing a database table to specify what column (or columns) make up the primary key.  Read more...
By Additional Articles 2006/12/22 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 2,888 reads

Our Very Own SQL Server Data Compression

Data space can be a concern in many situations as more and more data is being stored in your systems. Designing your schema to take this into account is important for a DBA and Steve Jones takes a look at how design decisions can be used to solve a business problem.   Read more...
By Steve Jones 2006/11/23 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 5,652 reads

Designing relational tables with subtypes

Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.  Read more...
By Additional Articles 2006/11/13 | Source: Builder.com | Category: basics
Rating:  Rate this |   Briefcase | 3,485 reads

A surrogate key architecture to perform powerful database operations

The alternative to surrogate keys is natural data keys. In order to understand the many substantial benefits of surrogate keys it's necessary to discuss some background on the issues involved.  Read more...
By Additional Articles 2006/01/10 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 4,008 reads

Database Design and Reference Tables

Whether you are building SQL Server 2000 applications or getting ready for the new features in SQL Server 2005, there are many fundamental database design principals that should be followed. New author Ranga Narasimhan brings us a look at how he handles reference tables when designing a database..   Read more...
By Ranga Narasimhan 2005/09/27 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 18,538 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,876 reads

SQL Building Blocks and Server Settings

This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.  Read more...
By Additional Articles 2005/03/09 | Source: It Toolbox | Category: basics
Rating:  Rate this |   Briefcase | 2,896 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,789 reads

Setting Matters Straight

Fabian Pascal, famed database author and writer takes his shots at a recent thread on another SQL site. He makes some good points about normalization.  Read more...
By Additional Articles 2005/01/20 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 2,724 reads

Lookup Table Design

Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.   Read more...
By Leo Peysakhovich 2004/07/27 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 22,675 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,876 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,872 reads

A Lookup Strategy Defined

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.   Read more...
By David Sumlin 2003/02/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,490 reads

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.   Read more...
By Brian Kelley 2003/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,130 reads

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.   Read more...
By Gregory Larsen 2002/12/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,017 reads

Designing a Flexible Task Management Database Part II

In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.   Read more...
By Jamie Voss 2002/10/17 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 4,641 reads
   Items 1 to 20 of 33    Older >>
 
Tags
sql server 7 (8)    
t-sql (5)    
administration (4)    
miscellaneous (4)    
programming (4)    
performance tuning (3)    
strategies (3)    
ado (2)    
configuring (2)    
indexing (2)    
naming standards (2)    
reviews (2)    
visual basic 6 (2)    
advanced (1)    
book reviews (1)    
data types (1)    
data warehousing (1)    
design and theory (1)    
installation (1)    
other (1)    
product reviews (1)    
rants (1)    
sql server 6.5 (1)    
stored procedures (1)    
system development life cycle (1)    
xml (1)