(Randy Dyess) Article which briefly discussed SQL Server’s data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
Author: SSWUG Research
Hitachi, Oracle Ally on Storage Technology
Hitachi and Oracle have announced they will strengthen an existing alliance, creating a partnership focused on improving integration of database management and information storage. Their first product will be a software library that enables administrators to more easily find and extract Oracle data
Multi-Level Collections in Oracle 9i
Steven Feuerstein and Bryn Llewellyn continue their series of articles on new Oracle 9i features with both simple and complex examples showing you how to work with multi-level collections.
Introduction to CCXML
By Hitesh Seth – When building interactive voice recognition applications, we are inevitably faced with the challenge of providing advanced telephony call-control capabilities. In some scenarios we’d like to bridge two calls for a conferencing application, in others we’d like to provide basic call r
HTML to Formatting Objects (FO) conversion guide
By Doug Tidwell – Need help converting HTML documents to PDF? This reference guide shows by example how to use XSLT templates to convert 45 commonly used HTML elements to formatting objects (from the XSL-FO vocabulary) for easy transformation to PDF using XSLT. The examples assume that you’re using
Formatting XML with the XmlTextWriter
This example demonstrates one way of formatting a string containing XML data using the XmlTextWriter. After loading the XML string into a DOM structure, the WriteTo() method of the XmlDocument is called to run the XML through the writer which will indent the different nodes appropriately.
Web Services Land in Yukon
By Darryl K. Taft – Web services will play a key role in Yukon, the next version of Microsoft Corp.’s SQL Server database, a company executive said. Giving a preview of the upcoming technology at the VSLive show here, David Campbell, product unit manager of the SQL Server Engine at Microsoft,
Determine How Deep FK Constraints
by Zlatko Sirotic – How do you determine how deep some foreign key constraints are? For example, EMP has a foreign key on DEPT, DEPT has a foreign key on DEPT_TYPE … With following solution, you don’t need to use a temporary table to determine the depth of foreign keys:
Using Java stored procedures: AOL instant messaging from Oracle
(Bradley D. Brown) Have you been wondering how you might use Java stored procedures instead of Oracle’s native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, the separation line for the database vs. App Server Java, perf
INF: Troubleshooting Application Performance with SQL Server
Troubleshooting performance issues involves using a series of steps to isolate and determine the cause of an application slowdown. Possible causes include blocking, system resource contention, application design problems, or a particular set of queries or stored procedures with long execution times.