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

3520 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

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

Beginning Database Design - Spot the Flaws

... issues, we as a group rarely write design articles. So I'm starting a series on basic design issues and ideas to help those of you ... I wanted to write a short series on designing tables since I see so many forum posts and questions out there on designing things. I know that so many ... even learn something from a few of the design gurus out there. While I chose ...

ARTICLE

Improving Database Design and Performance Using Compression

Introduction Designing databases is a common activity for most of us, and assigning ... usually keeps track of the growth trends of databases and the tables within them. For a DBA, maintaining ... utilized. When an application slows down and the database response is poor, there could be several contributing factors like a bad database layout, sub-optimal database design, ill-designed application code (no SP's / all ad ...