(By Dare Obasanjo, Microsoft Corporation) Inspiration for this article arose from a weekend where nothing that I expected to work on actually panned out. My significant other decided to take a celebratory trip to Las Vegas with a coworker, which coincided quite nicely with my plans to go to Ikea and
Author: SSWUG Research
The basics of using XML Schema to define elements
[Editorial] This is a great overview of using XML schemas – good, strong how-to piece. [/Editorial] <br><Br> The new XML Schema system aims to provide a rich grammatical structure for XML documents that overcomes the limitations of the DTD. This article demonstrates the flexibility of schemas and
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.
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
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.
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.
Enable all disabled constraints
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.
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
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
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.