SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag Database Design Rss

Refine your search with one of the following additional tags (with number of items):

Advanced (53)     Reviews (3)     constraints (1)     Name value pair (1)    
Miscellaneous (46)     System Development Life Cycle (3)     Denormalized (1)     NULL (1)    
Basics (29)     Visual Basic 6 (3)     Dependencies (1)     Other (1)    
Strategies (19)     ADO (2)     Design and Theory (1)     partition (1)    
SQL Server 7, 2000 (18)     Best Practices (2)     DRI (1)     Product Reviews (1)    
Programming (16)     Book Reviews (2)     Dynamic SQL (1)     Rants (1)    
T-SQL (16)     Career (2)     Editorial (1)     Referential Integrity (1)    
Administration (14)     Certifications (2)     Editorial - iPod (1)     Scalability (1)    
Naming Standards (13)     Monitoring (2)     Editorial - MP3 (1)     Schema (1)    
Data Types (11)     multi-tenant (2)     Editorial - WMV (1)     SQL Server 2005 - Security (1)    
Performance Tuning (7)     Normalization (2)     Effective Dating (1)     SQL Server 6.5 (1)    
Configuring (6)     SQL Server 2005 (2)     Encryption (1)     SQL Server Data Services (1)    
Data Modeling (6)     Stored Procedures (2)     Foreign Key (1)     SQL-DMO (1)    
Basic Querying (5)     XML (2)     humor (1)     SSDS (1)    
Indexing (5)     .Net (1)     IDENTITY (1)     UDM (1)    
Security (5)     Advanced Querying (1)     Installation (1)     UniqueIdentifier (1)    
Best and Worst Practices (3)     Auditing (1)     joe celko (1)     Views (1)    
Data Warehousing (3)     Blogs (1)     modelling and Entity relationship diagram (1)     Worst Practices (1)    

Search for any content tagged Database Design

   Items 1 to 20 of 220    Next 20 >>
 

Effective Dating Series Part I - The Problem

What are the benefits of Effective Dating and what problems does it solve?  Read more...
By Sam Bendayan 2009/10/01 | Source: SQLServerCentral.com | Category: Effective Dating
Rating: |  Discuss |  Briefcase | 6,655 reads

Querying a Multi-Tenant Data Architecture

This article discusses different ways to query multiple databases and shows a simple, web-based tool I've created and routinely use for those SaaS-style web applications I work on that use separate databases to store different customer data. Read on to learn more!   Read more...
By Additional Articles 2009/09/25 | Source: 4 Guys From Rolla | Category: Database Design
Rating: (not yet rated)  Rate this |  Briefcase | 1,840 reads

Multi-Tenant Data Architecture

The second article in our series about designing multi-tenant applications identifies three distinct approaches for creating data architectures.  Read more...
By Additional Articles 2009/09/24 | Source: Microsoft MSDN | Category: Database Design
Rating: (not yet rated)  Rate this |  Briefcase | 2,168 reads

Accommodating Null Values in SQL Server

The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.   Read more...
By Additional Articles 2009/09/16 | Source: DevX | Category: NULL
Rating:  Rate this |  Briefcase | 3,513 reads

What Data Should You Protect?

Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.  Read more...
By Steve Jones 2009/08/31 | Source: SQLServerCentral.com | Category: Editorial - MP3
Rating: (not yet rated)  Rate this |  Briefcase | 72 reads

What Data Should You Protect?

Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.  Read more...
By Steve Jones 2009/08/31 | Source: SQLServerCentral.com | Category: Editorial
Rating: |  Discuss |  Briefcase | 81 reads

What Data Should You Protect?

Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.  Read more...
By Steve Jones 2009/08/31 | Source: SQLServerCentral.com | Category: Editorial - WMV
Rating: (not yet rated)  Rate this |  Briefcase | 66 reads

What Data Should You Protect?

Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.  Read more...
By Steve Jones 2009/08/31 | Source: SQLServerCentral.com | Category: Editorial - iPod
Rating: (not yet rated)  Rate this |  Briefcase | 70 reads

Foreign Key Constraints Revisited

Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.  Read more...
By Additional Articles 2009/08/05 | Source: Database Journal | Category: Database Design
Rating: (not yet rated)  Rate this |  Briefcase | 2,205 reads

Object Grouping Best Practices: Using Schemas for Logical Separation

You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,  Read more...
By Hugo Shebbeare 2009/07/14 | Source: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 976 reads

Avoiding the EAV of Destruction

A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.  Read more...
By Additional Articles 2009/07/02 | Source: SimpleTalk | Category: Database Design
Rating: (not yet rated)  Rate this |  Briefcase | 1,365 reads

An Example of Test-Driven Development, Part 2

In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.  Read more...
By Andy Leonard 2009/06/16 | Source: SQLServerCentral.com | Category: Database Design
Rating: |  Discuss |  Briefcase | 6,956 reads

The 10 Essential Rules of Dimensional Modeling

Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.  Read more...
By Additional Articles 2009/06/16 | Source: Intelligent Enterprise | Category: Database Design
Rating:  Rate this |  Briefcase | 4,187 reads

Facts and Fallacies about First Normal Form

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.  Read more...
By Additional Articles 2009/06/09 | Source: SimpleTalk | Category: Database Design
Rating:  Rate this |  Briefcase | 4,688 reads

The Concept of Cardinal Reciprocity- A Primer

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.  Read more...
By Additional Articles 2009/04/01 | Source: SimpleTalk | Category: humor
Rating:  Rate this |  Briefcase | 2,163 reads

Ordering Tables To Preserve Referential Integrity

When moving data in related tables between databases, the order sometimes matters. New author Glen Cooper brings us an article that discusses the issues in maintaining referential integrity.  Read more...
By R Glen Cooper 2009/03/20 | Source: SQLServerCentral.com | Category: Database Design
Rating: |  Discuss |  Briefcase | 5,298 reads

SQL Data Services RDBMS Model

A preliminary look at the data model for SSDS.  Read more...
By Additional Articles 2009/03/13 | Source: Microsoft MSDN | Category: Database Design
Rating: (not yet rated)  Rate this |  Briefcase | 1,479 reads

Perils of adding fields to database tables

Adding a field to a database table is sometimes not as simple as it may seem. If certain situations are not considered when adding fields, you may find yourself looking at some long nights fixing database code. Today, database consultant Tim Chapman looks at two such scenarios, and how you can plan for their occurrence.  Read more...
By Additional Articles 2009/03/04 | Source: Builder.com | Category: Database Design
Rating:  Rate this |  Briefcase | 4,219 reads

Finding a better candidate for your clustered indexes

When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.   Read more...
By Additional Articles 2008/12/26 | Source: MSSQLTips.com | Category: Indexing
Rating:  Rate this |  Briefcase | 2,647 reads

Determine Object Dependencies Before Changing Your SQL Server Schema Design

Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.  Read more...
By Additional Articles 2008/12/11 | Source: DevX | Category: Database Design
Rating:  Rate this |  Briefcase | 1,902 reads
   Items 1 to 20 of 220    Next 20 >>
 
Most popular

Accommodating Null Values in SQL Server

The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.   Read more...
By Additional Articles 2009/09/16 | Source: DevX | Category: NULL
Rating:  Rate this |  Briefcase | 3,513 reads

The 10 Essential Rules of Dimensional Modeling

Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.  Read more...
By Additional Articles 2009/06/16 | Source: Intelligent Enterprise | Category: Database Design
Rating:  Rate this |  Briefcase | 4,187 reads

Facts and Fallacies about First Normal Form

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.  Read more...
By Additional Articles 2009/06/09 | Source: SimpleTalk | Category: Database Design
Rating:  Rate this |  Briefcase | 4,688 reads