Standard Query Languages White Papers

(View All Report Types)
Reduce CPU Usage with 'SMART' SQL
sponsored by BMC Software, Inc.
WHITE PAPER: This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.
Posted: 30 Nov 2009 | Published: 30 Nov 2009

BMC Software, Inc.

Guide to Consolidating SQL Server 2000 and SQL Server 2005 Databases to SQL Server 2008
sponsored by Dell and Microsoft SQL
WHITE PAPER: Read this paper for an informative guide to helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.
Posted: 12 Jul 2010 | Published: 30 Oct 2008

Dell and Microsoft SQL

Recovering Microsoft® Office SharePoint® Server Data: Granular Search and Recovery Means Time and Cost Savings
sponsored by Ontrack® PowerControls™ by Kroll Ontrack
WHITE PAPER: This paper spotlights the issues SharePoint administrators and IT administrators encounter when trying to recover SharePoint data and reveals a solution.
Posted: 10 Feb 2009 | Published: 10 Feb 2009

Ontrack® PowerControls™ by Kroll Ontrack

IBM Informix Software Product Family: Version 11.7
sponsored by IBM
WHITE PAPER: Read this paper to take a look at Informix 11.7 and you’ll discover unprecedented advantages. With the introduction of Informix Flexible Grid, it’s easy to perform routine maintenance and upgrades at all your geographic locations from a single site—and you can do it with zero downtime. Read on to learn more about the advantages of Informix 11.7.
Posted: 18 Mar 2011 | Published: 18 Mar 2011

IBM

Performance Optimization: Extending the IT Infrastructure
sponsored by Embarcadero Technologies, Inc.
WHITE PAPER: Performance optimization is a key ingredient in the struggle to stretch an invested IT dollar to its absolute limit. Read this whitepaper to learn about the 3-step 'prevent, find, fix' approach to handling performance optimization problems at any stage of the development lifecycle.
Posted: 29 May 2009 | Published: 29 May 2009

Embarcadero Technologies, Inc.

Business Intelligence—NoSQL… No Problem
sponsored by MongoDB, Inc.
WHITE PAPER: Find out how NoSQL databases can help your company meet the growing amounts of data in a manageable and usable fashion for BI. This paper gives an in-depth example at how MongoDB provides NoSQL benefits, as well as leveraging data in real-time, the benefits of document-oriented data, and examples of how users have implemented this to their BI.
Posted: 27 Aug 2012 | Published: 01 May 2012

MongoDB, Inc.

RedBook: Oracle to DB2 Conversion Guide - Compatibility Made Easy
sponsored by IBM
WHITE PAPER: New IBM DB2 features make compatibility easy. In this guide, you’ll learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more—all designed to improve your ability to run applications on both DB2 and Oracle platforms
Posted: 01 Sep 2010 | Published: 01 Sep 2010

IBM

Total Economic Impact of Oracle Enterprise Manager Database Management Packs
sponsored by Oracle Corporation
WHITE PAPER: This study highlights the benefits and costs of deploying the Oracle Enterprise Manager Diagnostic Pack and Tuning Pack across the enterprise of a sample organization. The study examines the estimated ROI for the sample organization and presents aggregate findings derived from the interview and analysis process and Forrester's independent research.
Posted: 18 Mar 2009 | Published: 18 Feb 2008

Oracle Corporation

SQL Compatibility in DB2 9.7-- From triggers to object enhancements: A demonstration of the new PL/SQL compatibility features
sponsored by IBM
WHITE PAPER: This article overviews the new PL/SQL compatibility features in IBM DB2 software version 9.7, making it easier to adopt and allowing you to take advantage of its autonomic and high-performance characteristics. 
Posted: 01 Sep 2010 | Published: 01 Sep 2010

IBM

Virtualize Microsoft SQL Server For Improved Performance With PowerEdge 11th Generation
sponsored by Dell and Microsoft SQL
WHITE PAPER: This white paper describes the benefits and performance of the latest Dell PowerEdge R810 running Microsoft SQL Server in VMware vSphere 4.0 Update 1 (U1) and EqualLogic PS6000XV iSCSI storage arrays.
Posted: 12 Jul 2010 | Published: 12 Jul 2010

Dell and Microsoft SQL