Fri, 14 Nov 2008 10:49:37 EST
Oracle management downsizing tips: Saving on Oracle hardware and software in a down economy
Learn how to reduce Oracle database costs with exclusive expert advice from Donald Burleson. Find out how to trim the fat without compromising security or quality.

Fri, 14 Nov 2008 10:49:37 EST
Best practices for saving on Oracle staffing costs in an uncertain economic climate (aka, what DBAs should know to keep from being laid off)
Find out how to downsize an Oracle shop -- or learn how your employers might approach this, so you can avoid being laid off. Learn the three common approaches from Donald Burleson.

Tue, 21 Oct 2008 11:52:09 EDT
Tips for derived tables in SQL and using FULL OUTER JOINs
SQL expert Rudy Limeback gives his strategy for using FULL OUTER JOINs on derived tables in SQL. Read the tip here.

Tue, 21 Oct 2008 11:52:09 EDT
Should we worry about Oracle memory leaks on Windows?
Oracle expert Brian Peasland explains how to evaluate if Oracle memory leaks will be an issue on a Windows platform and how to use Real Application Clusters (RAC) for scaling up and out.

Tue, 21 Oct 2008 11:52:09 EDT
How to create an SQL CHECK constraint for two letters
SQL expert Rudy Limeback explains how to create a SQL CHECK constraint for two letters when trying to write a query to retrieve data from two tables.

Tue, 21 Oct 2008 11:52:09 EDT
How to write an SQL query for two foreign keys to the same table
A SQL user asks how to write a query for two foreign keys to the same table. Read SQL expert Rudy Limeback's answer here.

Tue, 21 Oct 2008 11:52:09 EDT
How does Oracle instance recovery work and what happens internally?
Oracle expert Brian Peasland explains how an Oracle instance recovery works and what happens internally during the process in this tip.

Tue, 21 Oct 2008 11:52:09 EDT
What is a staging table, and how is the staging concept used in Oracle?
Expert Brian Peasland gives an example of what the staging concept is and how to use a staging table in Oracle.

Tue, 21 Oct 2008 11:52:09 EDT
How to delete a partition on the F: drive with Oracle on Windows
Get tips on how to delete and recreate a partition on the F: drive in which Oracle is installed.

Tue, 21 Oct 2008 11:52:09 EDT
What could be causing an SQL count 0 with a successful Oracle import?
Get tips for fixing the problem of getting an SQL count 0 with a successful Oracle import.