By Michael Nazareth – The following creates the script enable_cons.sql that enables all disabled constraints. It must be run by Oracle user SYSTEM. It has been tested on Oracle 7.3 onwards.
Other News
Find the Activities of Users
by Paul Subash – Description: This code provides details about the activities of database users (except SYS) and runs under Oracle8, Oracle8i, and Oracle9i databases.
Deleting obsolete data could save millions
By Liesbeth Evers – Network managers can save their companies millions by forcing users to delete old data, but only if they rid themselves of the “whipping boy” role. Four out of five company data records serve no business purpose because they contain orphaned, duplicated or stale data.
NetIQ Updates SQL Server Management Suite
By Barbara Darrow – NetIQ’s new SQL Management Suite 1.1, which is now being shipped, comes with two of its four component applications upgraded. The revised DiagnosticManager gives database administrators (DBAs) new reports and views and promises to help them better manage databases and tabl
Start to Finish Guide to SQL Server Performance Tuning
by K. Brian Kelley – While there are a lot of books that offer a chapter or two on how to use Performance Monitor (System Monitor) or Profiler to help tune SQL Server, it is hard to find in-depth information on this topic, that is, until now.
Working with email addresses in SQL Server!
By Vyas Kondreddi – This article shows you how to design the storage for email addresses, how to validate email addresses, how to write different types of queries on email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.
Das Yak ist Deutsch (RC #3)
From SQLTeam – Which is probably one of the oddest titled articles on the site. And after working on a solution myself and reviewing the ones submitted I know why Rob didn’t want to write these articles. We have some devious, creative SQL coders out there.
Oracle/SQL Tutorial
This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found under www.db.cs.ucdavis.edu/dbs. References to other SQL Tutorials and Oracle related material can be found
Using spreadsheets as Oracle tables
The advent of external tables in Oracle9i is exciting because it allows SQL queries to access any type of flat file, as if the data were stored inside an Oracle table. We’ll examine some caveats to this new approach, specifically
Master joins with these concepts
To efficiently handle queries and good database design, you must have a good understanding of SQL join statements. Beyond the logistics of basic syntax, there are several concepts that will round out your knowledge of joins and facilitate data referencing, such as aliasing, self joins, and ON clause