DatabaseJournal.com Staff

[From ITWeb] Johannesburg, 23 February 2004] – Enterprises currently running applications on Oracle Forms can now take advantage of the benefits of J2EE multi-tier environments. DeARX Services (Pty) Ltd offers a unique conversion tool called Exodus to provide companies with a smooth and very cost-effective solution to convert their current Oracle legacy systems to an […]

[From MySQL AB] The latest production version of MySQL was released on February 12. This release includes added and changed functionality and bug fixes. C.3.2 Changes in release 4.0.18 (12 Feb 2004) Functionality added or changed: Fixed processing of LOAD DATA by mysqlbinlog in remote mode. (Bug #1378) New utility program `myisam_ftdump’ was added to […]

>>Script Language and Platform: SQL Server The first step in preparing and maintaining an OLTP database for query and better performance is diagnosis. Maintaining statistics on a regular basis is important but a heavily updated database needs more emaphasis on Statistics. The following script (stored procedure) is useful in getting the information on which tables […]

[From Linux Journal ] Reasons why the Firebird database is a viable option for your next project. In the open-source world, much has been made about the need for a full-featured, robust and reliable database that can handle substantial loads and yet be able to play well with such open-source tools as Perl and PHP. […]

>>Script Language and Platform: SQL Server This script takes the current database and converts datafields of type NVarchar or text to varchar. Frequently, individuals will import/upsize Access DB to SQL Server, and SQL converts text and memos to Nvarchar or text when it isn’t necessary. Author: Gary Greenberg Download Script: NVarchar2Varchar.sql Disclaimer: We hope that […]

by Roman B. Melnyk and Paul C. Zikopoulos A view is a virtual table, meaning that no permanent storage is associated with the data in the view; rather, the permanent storage is associated with the table or tables on which the view is based. A view allows you to look at (and in some cases […]

slimdave@yahoo.com Current Articles:

>>Script Language and Platform: Oracle This script will get the number of rows per table in the current schema. Author: Shahid.Hafeez CREATE OR REPLACE FUNCTION Row_Count(Tbl_Name IN CHAR) RETURN NUMBER AS RowCount NUMBER(11); Stmnt VARCHAR(2000); BEGIN Stmnt := ‘SELECT count(*) FROM :tbl’ USING Tbl_Name; EXECUTE IMMEDIATE Stmnt INTO RowCount ; RETURN(RowCount); END; / select table_name,row_count(table_name) […]

[From ITWeb] [Johannesburg, 20 January 2004] – Large-scale enterprises need not pay extortionate amounts of money for high-end databases running on Unix platforms maintained by highly skilled, rare and expensive system administrators. But they do need to pay attention to the underlying system architecture, warns Bernard Donnelly, consultancy services manager: Unisys Africa. A centralised approach […]

By Paul C. Zikopoulos and Roman B. Melnyk The Version 8.1 release of IBM DB2 Universal Database (DB2 UDB) late last year came with the ability to start a new data stripe on the underlying storage units. In this article, we introduce you to this new feature and the problems that it solves, and take […]

>>Script Language and Platform: SQL Server Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation. Author: Alejandro Claver Download Script: html-excel.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, […]

Muthusamy Anantha Kumar, a.k.a. MAK, is a Microsoft Certified IT Professional – Database Administrator ( (MCITP: Database Administrator). He has more than 10 years of experience in Information Technology including database Administration, System Analysis, Design, Development and Support of MS SQL Server 2005/2000/7.0/6.5/6.0/4.X for production/development/testing. Article Series Current Articles