DBA Tips: SQL Server horizontal partitioning, and more...

[SearchDatabase.com]

Title: DBA Tips

April 21, 2004 Published by  SearchDatabase.com DBA Tips Issue Sponsored By: SearchDatabase.com Career Center IN THIS ISSUE: SQL Server: Horizontal partitioning DB2: How to create Web database apps with WDSC and VDM Oracle: 9i OLAP uncovered SQL Server: Guidelines for creating indexes Featured Topic: Data center decisions SQL Server: Horizontal partitioning [Barrie Sosinsky] A brief introduction to horizontal partitioning, a technique for large SQL Server databases that overcomes some of the problems associated with vertical partitioning. MORE INFO: Featured Topic: SQL Server tips and scripts SearchDatabase.com Career Center How does your salary compare to those of your peers? Visit SearchDatabase.com's Career Center powered by Dice and take our salary survey. Find training, certification, resume resources and over 27,000 IT job openings to search through. Register now and access a host of career resources! DB2: How to create Web database apps with WDSC and VDM [Jim Mason] An overview of the author's "Visual development method" that seeks to raise productivity and shorten the learning curve for DB2 iSeries/RPG developers who want to build Java Web applications. Oracle: 9i OLAP uncovered [Mark Rittman and Jon Mead] This detailed article outlines some of the key features of the Oracle9i OLAP option, explains how multidimensional OLAP data can now be incorporated into Oracle databases, and then made available to standard SQL-based Oracle tools and applications. SQL Server: Guidelines for creating indexes [Barrie Sosinsky] A well-performing database minimizes index creation while emphasizing the creation of the "right" mix of indexing. Here are some rules to guide you in your table designs when you are trying to decide what to index. ASK THE EXPERTS: Ask the Expert: Optional foreign key can be NULL Our SQL expert Rudy Limeback answers a question about applying an "optional" foreign key constraint where the foreign key column can be NULL if it does not match the primary or unique key of the parent table. TOPICS: Featured Topic: Data center decisions Interested in cutting-edge information about designing and managing reliable and cost-effective data centers? Read our advice, news analyses, and tips inside... Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?track=NL-94 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: SearchDatabase MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494