Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

4300 Results Found

ARTICLE

Bad Database Design

... Server have our share of bad database design stories. I’ve learned to be more ... years as I’ve managed both the database and developer sides of the effort, but even tolerance ... one came with a twist. Because the product was designed to run on just about any database platform, everything was built for the lowest common ...

ARTICLE

Stairway to Database Design

Designing a database is very easy to do, but hard to do well. There are many databases that have been built in the world that do ... meet the needs of the applications they support. The fundamentals of design are often not taught to developers or DBAs when ... looks to help you understand the fundamentals of the design process. The articles in the series are linked below: Stairway to Database Design - STEP 1: Data Elements - Before ...

ARTICLE

An Introduction to Database Design

... suggested that perhaps what Bob needed was a database - something like Access, perhaps. She explained that databases were much better at answering the sorts ... he was going to replace his spreadsheet with a database, he might as well use one ... Worse, when Bob used the query designer to show information for customer 123, it showed ...

ARTICLE

Database Design and Reference Tables

article is about smart database design. I have been programming in SQL ... than 8 years. I love the design and analysis phase of a project where you ... software project depends on its initial design. Once a poorly designed database hits production, no one will dare to make ...

ARTICLE

Have You Designed a Database from Scratch?

... I saw recently someone begin their blogging journey with a new post about designing a database. What struck me was this person with a lot ... lot of experience noted they had never designed a database from scratch. I'm sure that most of you have worked with a database, and have even modified various objects ... OLTP tables. However, have you designed a database from scratch? Not a standalone database, but a database the actually has an API or application built ...

ARTICLE

Stairway to Database Design Level 5: Procedures

... subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers. In level one, we named ... feeling of being done. In a very simple database, this is true. But in a real database there are more structures to consider. Among these other ... each table like a file and code as if the database is a procedural file system. You can ...

ARTICLE

Stairway to Database Design Level 9: Normalization

... us to the requirement that any atomic fact in the database (a collection of such tables) can be found by a table ... tracks on a disk. Nope. Wrong. Columnar databases are not contiguous storage. Neither is a hashed database. The first thing you have to do ... declared like this, and wanted to move it to a relational database. I picked Pascal because it is relatively ...

ARTICLE

Designing Cross Database Queries

Design: Working Across Databases I've been working with multiple databases recently in trying to tie a few applications ... I wanted to keep the data within the databases that it resides and perform some cross database work within applications. In doing so ... problem is that not all my data is in one database. When I first started working ...

ARTICLE

Best Practices for Database Design

... office and asks you to put together a database to manage some project they're working ... data or allow other users to access the database directly. This article will not focus on normalization and how ... look at how we name our databases, tables, columns, stored procedures and even ...

ARTICLE

Database Design Follies: NULL vs. NOT NULL

Introduction When designing a new database, one of the first decisions we make ... big implications for the future of our fledgling database.  Since NULL isn’t a value ... decisions right when you first design new tables will save immense trouble ...