DBA Tips: CHECK constraints, and more...

[SearchDatabase.com]

Title: DBA Tips

August 25, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Quest Software IN THIS ISSUE:   >  SQL Server: Data restriction using CHECK constraints   >  SQL Server: Performing incremental inserts/updates to reduce lock conditions   >  The DB2 UDB memory model   >  Oracle: Purge statspack snapshots to avoid data growth   >  Share your DBMS experience with fellow geeks   >  Spotlight on Sybase SQL Server: Data restriction using CHECK constraints [Barrie Sosinsky] You can use one or more CHECK constraints to limit the data that can be entered into your tables or column. Here's a quick primer on the subject. MORE INFO: > Hundreds more SQL Server tips and scripts   Maximize SQL Server Performance with SQL Tuning How proficient are you with tuning SELECT statements on SQL Server? Download Quest Software's Webcast and examine the techniques in Microsoft's SQL Enterprise Manager or SQL Query Analyzer and explore expert and time saving methods available with Quest's query tuning tools. Download the Webcast today.   SQL Server: Performing incremental inserts/updates to reduce lock conditions [Serdar Yegulalp] Inserts and updates are two of the most common operations in SQL Server that cause locking. Here is a quick overview of these types of locks and how to prevent them. The DB2 UDB memory model [Sylvia Qi & Michael Dang] Learn how DB2 UDB for Linux, UNIX and Windows uses memory, how that memory use varies by platform, and how it affects your applications. Oracle: Purge statspack snapshots to avoid data growth [Eric Mao] Do you find that sppurge.sql provided in statspack by Oracle not good enough? Here is a more efficient way to do the job. ASK THE EXPERT:  Share your DBMS experience with fellow geeks ITKnowledge Exchange is our new feature that allows Oracle, DB2, SQL Server, Sybase and MySQL pros to directly help one another solve pressing technical and strategic issues. Try it out! FEATURED TOPIC:  Spotlight on Sybase Sybase administrators and developers will benefit from the collection of technical tips, expert advice, news and market analysis, white papers, and webcasts 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 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494