(Debjani Mallick) Recovery Manager (RMAN) is a utility in Oracle that is generally used to backup, restore or recover database files. It performs backup and recovery by using database server sessions. The metadata about its operation may be stored in a control file of the target database or in recov
Other News
Outerjoins in Oracle
Since release 6, Oracle has supported a restricted form of left outerjoin, which uses Oracle-specific syntax. In 9i, Oracle introduced support for ANSI SQL 92/99 syntax for inner joins and various types of outerjoin. The Oracle syntax for left outerjoin and that of ANSI SQL 92/99 are not equivalent,
Ajax — A guide for the perplexed, Part 2: Develop a Dojo-based blog reader
(Gal Shachor, Ksenya Kveler and Maya Barnea) In this article, Part 2 of the series, the authors put your newly gained knowledge into practice by starting the development of a simple Dojo and Atom-based blog reader.
DB2 LUW Performance: I/O Write Times (OWMS)
(Scott Hayes) If your database updates its data via Inserts, Updates, Deletes, Imports, or Loads, then this blog post is for you. Write times tend to be slower than read times, and synchronous writes can be particularly painful. When tuning your databases, it is desirable to achieve a high percentag
Invisible Index in Oracle 11g
In release 11g, Oracle introduced a new feature of making an index invisible. During the index creation, one can specify whether index can be visible or invisible. We can also alter index to be visible or invisible. Invisible index is ignored by optimizer when computing the plan for a SQL.
Create database maintenance plans in SQL Server 2005 using SSIS
(Tim Chapman) In SQL Server 2005, database maintenance plans are almost entirely created using SQL Server 2005 Integration Services (SSIS). Microsoft provides a useful wizard to guide you through the creation process, but you are not required to use the wizard.
Installing SQL Server 2008
(Don Schlichting) This article will highlight the steps involved to install SQL Server 2008. The installation is simple and straightforward. Trial and preview versions can be downloaded from Microsoft at http://www.microsoft.com/sql/2008/prodinfo/download.mspx . If you’re new to SQL Server, then dec
Bin packing part 1: Setting a baseline
(Hugo Kornelis) Some problems can only be solved by brute-forcing every possible combination. The problem with such an approach, is that execution time grows exponentially as the amount of input data grows – so that even on the best possible hardware, you will get inacceptable performance once the i
Pivot and UnPivot with SSIS
(Dinesh Asanka) The presentation of your data is required for easy analysis. Turning columns into rows and rows into columns is another way of presenting your data so that end-users can understand it easily. Other than presentation purposes, you need to transform your data within your data warehouse
Just Add Sync, RS in Express Feedback Request
Latest SQL Server Show Live Now This SQL Server show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more. > Watch Now Also available Watch: SQLonCall Show – Interviews and more. Featured Article(s) New Features in […]