DBA Tips: SQL Server table fragmentation, and more...

[SearchDatabase.com]

Title: DBA Tips

October 06, 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: Identifying external or internal table fragmentation   >  Adding T-SQL functions to SQL Server system schema   >  SQL Server: Using AWE to increase performance   >  PASS: What's new in SQL Server 2005   >  400 DB2 questions answered   >  Your outlook on the data center   >  Analytics: Tips and advice SQL Server: Identifying external or internal table fragmentation [Eli Leiba] This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented). MORE INFO: > Hundreds more SQL Server tips and scripts   Optimize Oracle 9i Instance Memory Memory is one of the most critical system resources. 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" and take a closer took at instance memory features. Download the white paper.   Adding T-SQL functions to SQL Server system schema [Eli Leiba] This article describes how to add T-SQL functions to the SQL Server system schema for use by an entire server. SQL Server: Using AWE to increase performance [Baya Pavliashvili] Using "Address Windowing Extensions" (AWE) to increase memory usage will increase the performance of SQL Server. Here's how. PASS: What's new in SQL Server 2005 [SearchDatabase.com] Direct from the PASS conference last week, here's the latest about the cool (and controversial) new features coming in SQL Server 2005. 400 DB2 questions answered [SearchDatabase.com] Author and SearchDatabase.com expert Craig Mullins has just hit the milestone of answering a whopping 400 of your DB2 questions. Browse this invaluable resource and get answers to questions about DB2-specific SQL, Oracle comparisons, resolving error messages, and much more. SURVEY:  Your outlook on the data center What is your outlook on the future of the data center? What kinds of information on the data center would be most helpful to you? Take our survey and let us know what you think. FEATURED TOPIC:  Analytics: Tips and advice With data growing exponentially, business intelligence technologies are essential to maximize revenue and monitor corporate performance. Visit our collection of BI news, tips, & expert advice... 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