(Chris Smith) Database indexes help speed up retrieval of data, they can significantly improve performance – the other great benefit of that is your server doesn’t have to work as hard to get the data. They are much the same as book indexes, providing the database with quick jump points on where to
Author: SSWUG Research
New Directions For OLAP
(Seth Grimes) The online analytical processing tool arena is now in its second decade, and the focus of business intelligence innovation has shifted to dashboard displays, applications such as performance management, and operationally embedded analytics. That’s a hallmark of the acceptance of multid
Understanding Data Growth and Best Methodologies for SQL Optimization with Toad for Oracle Xpert
(Bryan Huddleston) If your shop has not experienced data growth in the last two-10 years, you are in the minority. The explosion of the information age has increased the amount of data we send, receive, process and use. Whether it’s customer or employee information, portals, dashboards or even perso
Error message when you run the sp_databases stored procedure in SQL Server 2000: ‘Arithmetic overflow error converting expression to data type int’
When you run the sp_databases stored procedure in Microsoft SQL Server 2000, you may receive the following error message: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 31 Arithmetic overflow error converting expression to data type int
Weaving WebSphere: Visual Studio vs. Eclipse (Round 1)
(Joe Pluta) My recent articles have leaned toward the overview side of the spectrum, being as they’ve been “first look” articles and coverage of topics from a managerial viewpoint. Not this one, dear reader. Despite the “Round 1” appellation, this article is going to quickly dive right into the nuts
V5R4 RPG Enhancements
(Ted Holt) The RPG compiler team is one fine bunch of practical people. From my perspective, everything they do seems to be motivated by the desire to help programmers do their jobs more easily, rather than by some theoretical, esoteric computer science concepts that have no practical value. (I will
Core Web Application Development With PHP and MySQL
(Pan Pantziarka) PHP and MySQL provide the development language and database components of the LAMP (Linux, Apache, MySQL and PHP/Perl/Python) stack that drives huge chunks of the web. Over the years they have each evolved and grown in complexity and functionality and yet they are still tied togethe
Service-Oriented Data Integration Architecture
(Soumendra Mohanty) Information management, which includes both data and content management, is an essential building block for service-oriented architectures (SOAs). Information management provides a means to represent, access, maintain, manage, analyze and integrate data and content across heterog
Surviving Common DB2 Per Performance Problems
(Craig S. Mullins) In today’s modern enterprise, information is power; and database systems are the predominant technology for storing, managing, and accessing the data that enterprises use to turn into information. And DB2 is one of the leading database systems on the market. (pdf)
First impressions of Oracle SQL Developer (formerly Raptor)
(edmon) Boastful ones call it a TOAD killer. Humbler ones call it a new, more able SQLPlus.