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

Content with tags Database Design, Basics Rss

<< Newer    Items 21 to 33 of 33   

Relational Database Without Relations

The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.   Read more...
By Eugene Bereznuk 2002/07/29 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,685 reads

Designing a Database with Microsoft Visio 2000

An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.   Read more...
By Bruce Szabo 2002/07/22 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 8,961 reads

Bill Wunder's DDL Archive Utility Launches as Freeware

Bill Wunder has donated his utility for those who have a free mebership. The DDL Archive Utility will look into a database and automatically archive the DDL from the database into Source Safe saving hours of hassles!   Read more...
By Bill Wunder 2002/07/11 | Source: | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 216 reads

Querying Responses

Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer.   Read more...
By Bruce Szabo 2002/06/28 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,427 reads

Storing Checkbox Responses as Integers

This article demonstrates how to store checkbox results as integers in a database...perfect for surveys!   Read more...
By Bruce Szabo 2002/06/27 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,178 reads

Designing a Flexible Task Management Database

In this article by Jamie Voss, he shows the methodology he used to develop his task management database.   Read more...
By Jamie Voss 2002/05/20 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 6,002 reads

Review of Debugging the Development Process

Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read.   Read more...
By Andy Warren 2002/02/26 | Source: | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,255 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: | Category: installation
Rating: |  Discuss |   Briefcase | 35,851 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,238 reads

Using Uniqueindentifier Instead of Identity

Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.   Read more...
By Andy Warren 2001/09/17 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 11,424 reads

Design Oversight - Preliminary Review

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.   Read more...
By Brian Kelley 2001/08/20 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 8,186 reads

Upsize Your Database: Convert Your Microsoft Acces

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.   Read more...
By Additional Articles 2001/08/09 | Source: Microsoft MSDN | Category: basics
Rating:  Rate this |   Briefcase | 1,422 reads

Prove Your Case and Win a Buck!

Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.   Read more...
By Sean Burke 2001/05/21 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 3,315 reads
<< Newer    Items 21 to 33 of 33   
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 warehousing (1)    
datatypes (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)