DBA Tips: Sorting with CASE expressions, end-user woes, and more...

[SearchDatabase.com]

Title: DBA Tips

September 15, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Texas Memory Systems   > PolyServe, Inc. IN THIS ISSUE:   >  SQL Server: Sorting output with CASE expressions for custom sort orders   >  DB2 database design and principles of peak performance   >  DBAs discuss end-user woes   >  Why every performance tool stinks   >  ITKE it!   >  Beyond the 'Big 3' 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. MORE INFO: > Hundreds more SQL Server tips and scripts   DATABASE PERFORMANCE UP TO 2500% FASTER FREE WHITE PAPER: "Increase Application Performance with Solid State Disk." Learn how you can speed applications like OLTP databases, batch processes, and data warehouses up to 2500% with the World's Fastest Storage® from Texas Memory Systems. View performance benchmarks from the vendor-neutral Storage Performance Council. Download this free white paper now or call 713-266-3200x510.   DB2 database design and principles of peak performance [Fred Whitlark] Many design decisions made early during the development process can have a significant influence on the performance of your DB2 applications and databases. This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments. 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. 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!   Achieving Flexible Database Clusters with Oracle Learn the advantages of scalable on-demand clusters with Oracle9i RAC. IBM and PolyServe authors introduce the computing infrastructure known as Flexible Database Clusters and illustrate with a 14-node cluster of IBM Linux servers running Oracle9i RAC PolyServe cluster software. Attached to a formidable SAN configured with 206 disk drives, the cluster was tested with three database workloads. Click Here to View this Free White Paper.   FEATURED TOPIC:  Beyond the 'Big 3' There is life beyond the big three DBMS vendors! Sybase, MySQL, and others have found significant niches in enterprise IT. Our collection of news, tips, and expert advice has all the info you need about the "best of the rest." 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