DatabaseJournal.com Staff

[From Vista Software] VistaDB 2.0 (Beta 3) database engine for .NET is now available for download. Beta 3 is a significant improvement over previous builds. The $129 special introductory price ($329 Regular) has been extended. VistaDB is the #1 alternative to Access/JET, MSDE, xBase and in some cases SQL Server, for building robust small to […]

>>Script Language and Platform: SQL Server This script returns the number of rows in each table for a database. Author: Shyam SKJ create procedure [dbo].[DisplayRowCount] as declare @tabcnt int declare @printline char (60) select @tabcnt = count (*) from sysobjects where type = ‘U’ If @tabcnt != 0 BEGIN select “TABLE NAME”= convert (varchar (50), […]

>>Script Language and Platform: VBScript, SQL Server This VBScript allows you to search files that are a few days old, in a folder for a keyword. It is useful to search files like archived log files in the same folder so that you can look in to only those log files which have the keywords. […]

>>Script Language and Platform: SQL Server 2000 This script spells out any integer number in words. Usage: SELECT dbo.udf_spellnumbers (70000) –result SEVEN ZERO ZERO ZERO ZERO SELECT dbo.udf_spellnumbers (1234567890) –result ONE TWO THREE FOUR FIVE SIX SEVEN EIGHT NINE ZERO Author: MAK Create function dbo.udf_spellnumbers (@big bigint) returns varchar(1000) as begin –declare @big bigint –Created […]

by Paul C. Zikopoulos and Roman B. Melnyk If you come from a Windows background, you are likely to leverage a graphical user interface (GUI) to perform most of the management tasks for your environment, including managing your IBM DB2 Universal Database (DB2 UDB) server. The Control Center is the GUI tool that provides database […]

[From Microsoft Corp.] AMSTERDAM, Netherlands — June 29, 2004 — Today at Tech-Ed Europe, Microsoft Corp. announced the expansion of Microsoft® SQL Server (TM) and Visual Studio® product lines to include new tools for hobbyists, enthusiasts and students. The Express products offer lightweight, easy-to-use and easy-to-learn products that enable the nonprofessional to quickly build exciting, […]

by Paul C. Zikopoulos and Roman B. Melnyk If you are a systems administrator whose responsibilities include deploying DB2 Universal Database (DB2 UDB) for Windows software, there are some new features in DB2 UDB "Stinger" that are going to make your job easier. In this article, we will introduce you to the new DB2 Run-Time […]

by Roman B. Melnyk and Paul C. Zikopoulos The technology preview of the next release of IBM DB2 Universal Database (DB2 UDB) for Linux , UNIX , and Windows is codenamed “Stinger”. As of the publication date of this article, it is available as an open beta for download at: http://www.ibm.com/data/stinger. This article is another […]

>>Script Language and Platform: Oracle 8i and above Find datafiles added per month for version 8 and above. Author: Narasimham,Softenger India pvt limited select d .name,to_char(creation_time,’MON-YY’) creation_date, sum(bytes)/1024/1024 “size” from v$datafile, v$database d where to_char(creation_time,’YY’)= to_char(sysdate,’YY’) group by d .name,to_char(creation_time,’MON-YY’) order by to_char(creation_time,’MON-YY’) ; Disclaimer: We hope that the information on these script pages is […]

>>Script Language and Platform: Oracle This is brief information about control file.Take the controlfile information from trace file and does changes accordingly. Author: keepquite@yahoo.com alter database create standby controlfile as ‘/path’; alter database backup controlfile to trace; create controlfile REUSE set database orders_2 logfile group 1 (d:orawinorawingopalg.log1) group 2 (d:orawinorawingopalg.log2) RESETLOGS/NORESETLOGS Datafile ‘c:windowsgopalgo.data1’ size 2m, […]

>>Script Language and Platform: Oracle This script will show you your tablespace size, what percentage is used and free, and the number of fragments that happened. Author: Narasimham,Softenger India pvt limited col tablespace format a11 set linesize 119 select substr(a.TABLESPACE,1,5) tablespace, a.SIZE_IN_MB,b.FREE_IN_MB,b.MAX_IN_MB, rpad(ROUND((b.FREE_IN_MB/a.SIZE_IN_MB)*100,2),5) FREE_PCT,substr(b.FRAG#,1,5) FRAGS# from dual, (select tablespace_name TABLESPACE, rpad(round(sum(bytes)/1024/1024,2),5) SIZE_IN_MB from dba_data_files group […]

[From internetnews.com] Sleepycat Software is seeing value in the Java brand. So much so that it released a new version of its database software, which is written in pure Java. Based on a write-once, append-only log architecture, the company’s Berkeley DB Java Edition is significant for Sleepycat in that it keeps them competitive with other […]