If you need a temporary table to persist across non-nested stored procedures and then you want to drop the temporary table when you no longer need it, you can dynamically create permanent tables in your code. This article provides an example of this procedure.
Author: SSWUG Research
Roadmap for Programming XML with the Pull-Model Parser in the .NET Framework
This article provides a roadmap for programming XML with the pull-model parser of the .NET Framework. To help with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and white papers.
DB2 UDB v8.1 Express: Initial Configuration and Rules of Thumb
(Fraser McArthur) The goal of this document is to give straight forward and easy to implement recommendations which can lead to a well-performing DB2 UDB V8 Express system. This document covers several easy-to-use utilities and provides some useful rules of thumb for database configuration.
Unauthorized Access to Restricted Content in Oracle Files
A potential security vulnerability has been discovered in the Oracle Files component that ships with Oracle Collaboration Suite Release 1. A knowledgeable and malicious user of Oracle Files can potentially access restricted content. In the Oracle Files component that ships with Oracle Collaborat
Dates in Oracle 8i and earlier versions
(Philip Greenspun) From version 9 onwards it is possible to represent points in time and time intervals using ANSI SQL data types such as timestamp and interval. We strongly recommend that you use the newly available ANSI data types when building new applications. Visit the main chapter on dates for
XSL Transformations (XSLT)
This specification defines the syntax and semantics of XSLT, which is a language for transforming XML documents into other XML documents. XSLT is designed for use as part of XSL, which is a stylesheet language for XML. In addition to XSLT, XSL includes an XML vocabulary for specifying formatting.
Adding Conflict Resolution Features to a Query Language for Database Federations
(Kai-Uwe Sattler, Stefan Conrad, and Gunter Saake) A main problem of data integration is the treatment of conflicts caused by different modeling of real-world entities, different data models or simply by different representations of one and the same object. During the integration phase these conflic
How to Shrink the SQL Server 7.0 Transaction Log
There are some common reasons why a transaction log might not shrink when you use the DBCC SHRINKFILE or DBCC SHRINKDATABASE command. The SQL Server Books Online topics “DBCC SHRINKFILE” and “DBCC SHRINKDATABASE” provide detailed information, but a brief summary follows.
Tips on optimizing your SQL Server indexes
Within SQL Server there are several tools that you can employ to monitor, tune, and optimize performance. Here, I will explain how to utilize and interpret the results of SQL Server tools to optimize the use of database indexes. I’ll also discuss general indexing topics. Indexes are one of the b
A Simple Approach to Index Redesign
(Martin Hubel) Through my years of tuning DB2 applications on platforms ranging from mainframes to workstations, I am rarely called in before a problem has occurred. This means fixing an application to either achieve or restore acceptable performance. I often find that the application is not writ