DBA Tips: SQL Server clustering, Oracle tuning, and more...

[SearchDatabase.com]

Title: DBA Tips

September 22, 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: Why cluster?   >  Oracle tuning: Blocksize and index tree structures   >  DBAs discuss end-user woes   >  Why every performance tool stinks   >  SQL Server: Sorting output with CASE expressions for custom sort orders   >  ITKE it!   >  Life as a DBA SQL Server: Why cluster? [Buck Wood] There are two types of clustering in SQL Server: load balancing and failover. This short article examines the reasons for clustering and some of the system requirements. MORE INFO: > Hundreds more SQL Server tips and scripts   Optimize Oracle 9i Instance Memory Learn how dynamic SGA, automatic SQL execution management and Oracle advisories and their use in resizing can help optimize instance memory management in your environment. Download Quest Software's white paper "Optimizing Oracle 9i Instance Memory." Click here to download   Oracle tuning: Blocksize and index tree structures [Donald K. Burleson] Guru Don Burleson makes the case that the multiple blocksize feature improves the performance of Oracle indexes and that there are cases where query speed is improved by rebuilding indexes. DBAs discuss end-user woes [SearchDatabase.com] Some end users are happy with a short wait when calling up an application, others can be downright hostile. Properly managing the different pockets of end users in an organization is the key to being a successful DBA. Why every performance tool stinks [Craig Shallahamer] Craig Shallahamer, who makes a living planning and optimizing Oracle-based systems, thinks every DBMS performance tool stinks, including his own. Here's why. SQL Server: Sorting output with CASE expressions for custom sort orders [Serdar Yegulalp] Sometimes, a recordset will need to be returned with a non-standard sort order -- something that isn't possible with conventional sort or collation mechanisms. Here is a quick tip about how to use the ORDER BY CASE clause. ITKNOWLEDGE EXCHANGE:  ITKE it! ITKnowledge Exchange (ITKE) is our innovative 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:  Life as a DBA The DBA life has always been challenging but now new threats are emerging. The tips and advice inside will guide you along the perilous path to becoming a database guru... 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