DatabaseJournal.com Staff

by MAK [Muthusamy Anantha Kumar] In the typical IT department, an un-avoidable task is to monitor the disk space on all drives on certain servers. In addition, the methods presented here will help in monitoring the growth of files. In this article, I am going to discuss three different ways to monitor disk space on […]

Sp_Help displays all the information regarding a given table. When information is required only on one particular field then this stored procedure can be used with SQL Server 7.0. Syntax: sp_HelpTableField ‘TableName’ , ‘Substring of FieldName’. All the field names matching this ‘Substring’ will be displayed. Author: Neeraj Hora Download Script: sp_helpTableField.sql Disclaimer: We hope […]

[From Oracle Corp.] Jan. 7, 2004 – (http://www.oracle.com/tellmemore/?2706878) Oracle Corp. today announced with HP a world record non-clustered TPC-H 10 terabyte benchmark result for Oracle(r) Database 10g running on an HP Integrity Superdome server with HP-UX, highlighting the companies’ ability to satisfy customers’ most demanding decision support and data warehousing requirements. Running on an HP […]

[From AASoftech Inc. ] AASoftech Inc. provides an interface that enables you to generate an organizational chart using Oracle database. Web Organization Chart (Ora Version) is used to connect to the Oracle database. Ora version of “Web Organization Chart” selects information from the Oracle (HR) tables and converts it into a format that is readable […]

This procedure will generate a delete stored procedure against a provided table and column name in your database. The script searches for foriegn key constraints and then creates a delete statement for each one found in the database. The procedure has three parameters: @table_name nvarchar(128) – The name of the source table @column_name nvarchar(128) – […]

by MAK [Muthusamy Anantha Kumar] Data Base Administrators are often exposed to a situation where they want to query a table, check on the status of a server, check an error log or run a DBCC command on a SQL Server box when they do not have access to the box directly. This often happens […]

[From MySQL AB] MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is the first Alpha development release of the 5.0 tree, adding […]

>>Script Language and Platform: Oracle This script will generate INDEX CREATION script for all table foreign keys when they are part of primary keys. This is usefull when you need to generate index for reference columns especially for DW applications. Author: Shahid Hafeez Download Script: foreign_keys Disclaimer: We hope that the information on these script […]

by Duncan Pauly Burgeoning data volumes continue to place organisations’ IT departments under greater strain than ever as they look to harness data effectively while overcoming a minefield of performance issues. The importance of the data warehouse in attaining the maximum benefit from data has grown exponentially, with its promise to provide an enterprise-wide view […]

[From Builder.com] One of the most confounding problems with Oracle is the resolution of buffer busy wait events. Buffer busy waits are common in an I/O-bound Oracle system, as evidenced by any system with read (sequential/scattered) waits in the top-five waits in the Oracle STATSPACK report, like this: Top 5 Timed Events % Total Event […]

[From PremiumSoft CyberTech Ltd.] Navicat (MySQL Client for Mac OS X) is a set of graphical database management and monitoring tools for MySQL database systems. Navicat version 4.4.2 (Mac OS X) includes these new features : You can convert your DBF, CSV, Text or XML files to MySQL databases. Duplicate Tables and Empty Tables Export […]

[From O’Reilly ONLamp.com] If you are a DBA or a database programmer, your manager may have asked you to prepare a breakdown of employees by location and department, or a breakdown of products by category and provider. If your boss is a techie, instead of a breakdown she might have mentioned a pivot table, or, […]