DatabaseJournal.com Staff

Marin Komadina Today the server hardware is so powerful that it is not unusual to find standalone low cost SMP (Symmetric Multiprocessing Machine) servers in different clustered and non-clustered configurations. Data volume and the number of concurrent database connections on those systems are rising higher and higher. When we approach warning levels in our hardware […]

>>Script Language and Platform: SQL Server 2000 User-Defined Functions At our consulting firm, we record time in minutes, and we round those minutes up to the next quarter hour; for reporting purposes, we bill according to hours used. This function requires an input of minutes used, and will return the results rounded to the next […]

>>Script Language and Platform: SQL Server 2000 User-Defined Functions This user-defined function will return the Monday before or the Sunday after any given date. I use this function primarily to categorize service activities for our business; our weekly calendar runs from Monday to Sunday. Usage is simple: SELECT dbo.udfBusinessWeek(GetDate(), ‘B’) to return the Monday of […]

by Ajay Gursahani With Oracle 9i’s new feature, RESUME, you can suspend or resume operations that run out of space, or reach space limitations after executing for long time. In Oracle 9i we can switch a transaction into ‘resumable’ mode. This means that any errors arising due to lack of space will not cause a […]

>>Script Language and Platform: Oracle 8+ This script is useful for finding out how rows in a table are spread across different datafiles and how many rows are there in each datafile for that table. Author: K.Chithra ACCEPT OWNER CHAR PROMPT “ENTER OWNER NAME : ” ACCEPT TABNAME CHAR PROMPT “ENTER TABLE NAME : ” […]

Data warehouse environments typically involve extraction, transformation, and loading data into the data warehouse from the source systems. Very often, the requirement is to capture the incrementally changed data (delta) from the source system with respect to the previous extract and load into the data warehouse. Oracle database provides multiple options and features to implement […]

by Muthusamy Anantha Kumar SQL Mail (MAPI) is not cluster aware. However, Email/Pager messages are very important for Technology Administrators, especially when a job fails or an alert is triggered. In a Non-Cluster environment, it would be a straightforward process to set up SQLMail. To set mail up on an SQL Server Cluster Server, we […]

by Insanely Great This article discusses a solution to bring two remote MySQL databases in Sync with each other using a Free MySQL Admin Tool called SQLyog. You can download the latest version of SQLyog at Webyog Overview As PHP/MySQL developers, we very often see ourselves working on a test server from where we need […]

[From askSam] Perry, FL — askSam Systems has released the askSam Viewer, a free viewer for askSam databases. The askSam Viewer allows users to browse, search, navigate with hypertext links, and run reports in askSam databases. The askSam Viewer lets users browse and search through manuals, catalogs, research notes, legal texts, government regulations, resumes, or […]

Neil Boyle Neil Boyle left school at the age of sixteen thinking that computers were things that only existed in Star Trek. After failed careers as a Diesel Mechanic, Industrial Cleaner, Barman and Bulldozer Driver he went back to college to complete his education. Since graduating from North Staffs Poly he has worked up through […]

[From Linux Today] The SCO Group (SCO) has announced that SCO Linux 4.0 has been certified with the latest edition of IBM DB2, Version 8.1. This certification allows companies using SCO Linux to simplify and automate many of the tasks associated with maintaining their database systems. SCO Linux 4.0 is a Linux operating system designed […]

>>Script Language and Platform: SQL Server This Stored Procedure can attach multiple data files that have the *.mdf or *.ldf Extention .. Example : You have multiple data files on your “c:SQL_data directory” … Just type this on your query analyzer–of course you have to be a member of sysadmin fixed server role. exec attach_db […]