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

<< 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,654 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: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 8,947 reads

Bill Wunder's DDL Archive Utility Launches as Freeware

Bill Wunder has donated his utility for those who have a free SQLServerCentral.com 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: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 200 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,418 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,171 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: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 5,967 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: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,254 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,684 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,232 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: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 11,403 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,183 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,384 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: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 3,314 reads
<< Newer    Items 21 to 33 of 33   
 
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)