
	Home > Ask the SQL Server Experts > Kevin Kline - Monitoring/Administration Questions & Answers > Database design resources

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

Database design resources

EXPERT RESPONSE FROM: Kevin Kline

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database administration

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 24 August 2005
I'm trying to build an archive of documents, (it may be called a digital library), and could use some help in setting up the tables for categories, subs and themes. Where can I go for guidance?

EXPERT RESPONSE
It sounds like you really want some help on the fundamentals of database design. If you haven't been schooled in the principles of database design, I recommend Louis Davidson's book (soon to be in its 2nd edition), Pro SQL Server 2000 Database Design.

The University of Texas at Austin has a good overview of normalization techniques at this site.

InformIT author Buck Woody has a series of articles about database design at this page.

Finally, there are other good Web sites that can help. Fellow MVP, Bill Graziano runs the SQL Team site. For performance-related issues, always look at SQL-Server-Performance.com maintained by fellow MVP Brad McGeehee. Check out this database design article in particular.

Do you have comments on this Ask the Expert Q&A? Let us know.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Kevin Kline - Monitoring/Administration
	Publisher residing on a different domain
	SQL Mail troubleshooting
	Installing SQL Server client tools on Windows XP Pro
	Incorrect drive letter assignments
	Installing SQL Server 2000 Enterprise Edition on Windows XP
	Identifier field in Microsoft's SQL Server
	Getting scheduled DTS packages to run
	Performance problems after installing Windows Service Pack 4
	Improve performance by spreading data
	Difficulties transferring stored procedures and triggers

SQL Server database design and modeling

SQL Server database design disasters: How it all starts

Physical data storage in SQL Server 2005 and 2008

SQL Server 2008 data types: Datetime, string, user-defined and more

SQL Server and data manipulation in T-SQL

Enforcing data integrity in a SQL Server database

Supertype and subtype tables in SQL Server

SQL Server database design disasters: What not to do

Check SQL Server database and log file size with this stored procedure

SQL Server tempdb best practices increase performance

FAQ: SQL Server databases how-to

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

binary tree (SearchSQLServer.com)

block (SearchSQLServer.com)

data structure (SearchSQLServer.com)

DDBMS (SearchSQLServer.com)

entity-relationship model (SearchSQLServer.com)

initial extent (SearchSQLServer.com)

primary key (SearchSQLServer.com)

segment (SearchSQLServer.com)

tablespace (SearchSQLServer.com)

view (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2005 - 2008, TechTarget \| Read our Privacy Policy