SQL Server database design and modeling

MUST READ SQL Server database design disasters: What not to do TIP - Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance. Physical data storage in SQL Server 2005 and 2008 BOOK EXCERPT - Learn the fundamentals of data storage in SQL Server 2005 and 2008, including tables, views and data types, in this book excerpt. Designing SQL Server non-clustered indexes for query optimization TIP - Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes. Creating SQL Server tables and columns: Quick tips to know TIP - Improve performance of SQL Server tables and columns by defining data types, indexes, keys, partitions and more. Create SQL Server columns and tables with these best practices. Optimize disk configuration in SQL Server TIP - Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.

EXPERT TECHNICAL ADVICE: 1 - 3 of 93

	SQL Server database design disasters: How it all starts Submitted By: SearchSQLServer.com | 24 Sep 2008 TIP - SQL Server database design and high performance are tied to filling the role of both production DBA and development DBA for SQL Server.

	SQL Server database design disasters: What not to do Submitted By: SearchSQLServer.com | 15 Sep 2008 TIP - Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.

	Check SQL Server database and log file size with this stored procedure 13 May 2008 TIP - Check the size of your SQL Server database with the undocumented stored procedure sp_SDS and get results beyond sp_spaceused. Also calculate log file size and monitor DB growth.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER DATABASE DESIGN AND MODELING

REFERENCE & LEARNING: 1 - 3 of 67

	Top 10 SQL Server Tips of 2008 SearchSQLServer.com | 16 Dec 2008 THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2008 on topics such as clustered index design, log shipping setup, date/time data conversions and many other aspects of SQL Server.

	Tutorial: SQL Server indexing tips to improve performance SearchSQLServer.com | 03 Dec 2008 TUTORIAL - Significantly improve your SQL Server performance through this tutorial on proper indexing choices. Learn how to design high performing indexes and tune your existing SQL indexes.

	Supertype and subtype tables in SQL Server SearchSQLServer.com | 16 Sep 2008 BOOK EXCERPT - Learn how to physically implement supertype and subtype tables on a SQL Server in this book excerpt.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER DATABASE DESIGN AND MODELING

NEWS: 1 - 3 of 6

	SQL Server DBMS' growing popularity is no coincidence SearchSQLServer.com | 05.26.2006 OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...

	Q&A: Making the jump to 64-bit SQL Server 2005 SearchSQLServer.com | 24 Jan 2006 INTERVIEW - SQL Server 2005 was designed to harness 64-bit technology. Contributor Adam Machanic answers some common 64-bit questions and offers advice for making the upgrade.

	Letters to the editor: Educating database end users SearchSQLServer.com | 11 Jan 2006 LETTERS TO THE EDITOR - As a SQL Server DBA or developer, what knowledge would you pass along to end users to help ease your burdens in the new year? Read what your peers have to say.

	VIEW ALL NEWS ON SQL SERVER DATABASE DESIGN AND MODELING

BEST WEB LINKS: 1 - 3 of 3

	SQL Server World Wide User Group Help Center http://www.sswug.org/ | 22 Jul 2005 BEST WEB LINK - This Web site allows subscribers access to educational webcasts, discussion forums, database news, script manager and e-mail discussion lists

	Introduction to Microsoft SQL Server About.com | 22 Jul 2005 BEST WEB LINK - Here is a comprehensive introduction to Microsoft SQL Server 2000, which details the various tools available to SQL Server users.

	Achieving massive scalability with SQL Server SQL-Server-Performance.com | 07 Mar 2005 BEST WEB LINK - Doug Kerwin explains how to achieve massive scalability with SQL Server using techniques such as clustering, federated database design and continuous replication.

	VIEW ALL BEST WEB LINKS ON SQL SERVER DATABASE DESIGN AND MODELING

DEFINITIONS: 1 - 3 of 24

	entity-relationship model 09 Feb 2004 WORD - The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database. The ER model was first proposed by Peter Pin-Shan Chen of ...

	DDBMS 28 Oct 2003 WORD - A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer. The DDBMS synchronizes all the data periodically, and in cases ...

	view 01 Nov 2003 WORD - In a database management system, a view is a way of portraying information in the database. This can be done by arranging the data items in a specific order, by highlighting certain items, or by showing only certain items. ...

	VIEW ALL DEFINITIONS ON SQL SERVER DATABASE DESIGN AND MODELING

	SEE ALSO - Topics Related to SQL Server database design and modeling:  SQL Server installation, SQL Server integration/interoperability, SQL Server replication, SQL Server performance and tuning, SQL Server Online Transaction Processing (OLTP), SQL Server backup and recovery, SQL Server clustering, SQL Server security, SQL Server availability, SQL Server data warehousing/business intelligence