Recursive techniques in stored procedures in T-SQL offer you a powerful way to analyze your database and return results from queries. See how in this article from SQL Server Professional Magazine.
Author: SSWUG Research
Installation Problem Determination
The objective of this tutorial is to guide you through common types of problems during DB2 installation and FixPak upgrades and how to solve such problems.
IBM previews DB2 upgrade
IBM will unveil enhancements to the next version of the DB2 database which are to help simplify development of applications for the Microsoft .net platform at the Microsoft Professional Developers Conference 2003 in Los Angeles.
Generating Code for Fast Copying
by Norman Spector – Here is a script which will dynamically generate code for fast copying of tables to another database or another account. It very useful for fast scalable refresh of presentation tables in data warehousing projects, where production tables are very bulky.
Years of Testing Proves SharePlex®for Oracle Effective for the UK’s Roadside Service Agency, "RAC"
Royal Auto Club (RAC), serving millions of motorists per year throughout the UK, operates under one of the most stringent service levels possible – they must respond to stranded motorists within a pre-determined time of the driver’s distress call. Since 1998, Quest Software’s SharePlex® for Oracle h
How to identify the service pack installed on your SQL Server?
By Vyas Kondreddi – This article shows you different ways for finding out the service pack installed on your SQL Server. Contains a nice chart with SQL Server build numbers along with the corresponding service pack numbers.
A Practical Guide to SQL Server Yukon Beta 1 DTS
This white paper provides a practical guide to exploring the new features of the “Yukon” DTS platform.
Introduction to JDBC
(Nathan Folkert)This document illustrates the basics of the JDBC (Java Database Connectivity) API (Application Program Interface). Here, you will learn to use the basic JDBC API to create tables, insert values, query tables, retrieve results, update tables, create prepared statements, perform transa
Exploring Yukon Territory
With the Yukon release of SQL Server now in private beta, SQL Server Magazine talked with Microsoft’s Eric Brown about the release’s long-awaited development and administration enhancements and how you can start preparing for the changes ahead.
Take a Load Off: Archive Inactive Data
By Bryan F. Smith and Thomas A. Vogel – A data explosion threatens to bog down, fill up, and generally complicate DBMSs. Archiving lets companies hold on to the data they need and keep DB2 performing at top speed.