In Microsoft SQL Server 2000 Service Pack 3 (SP3), shared page locks can be held until the end of the transaction. This behavior may lead to blocking or performance problems.
Author: SSWUG Research
Tutorial: Changing the Visibility Objects in Reporting Services
(Brian Knight) In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we’ve created our first report and have added a bit of flare to it, let’s go ahead and make it even cleaner. In this very quick demonstration, we’ll go ahead and
T-SQL’s Datetime Data Type
(Michael Otey) SQL Server’s datetime data type generates a lot of questions and confusion in the SQL Server community. Unlike some other major database platforms, SQL Server doesn’t provide discrete date and time data types. Instead, SQL Server’s datetime data type does the work of both. Here are an
Find Last Entry from History
(Galina Petrenko) The following technique shows how to find the last record ( last entry ) from the history table. When the history table has a timestamp column, you can use an N-Row query with a descending sort on that column and get just one row. Use similar techniques when the timestamp column is
FIX: A redirected request causes the waitForResponse method of the ServerXMLHTTP class to fail
You may use an object of the ServerXMLHTTP class to establish an HTTP connection to a Web site. When the Web site redirects your request to another Web site, the waitForResponse method of the ServerXMLHTTP class fails, and you receive the following error message: This method cannot be called unti
Uploading a Large Number of Records in DB2
(Gautham Muthuravichandran) When you’re carrying out an database-intensive operations, like trying to insert a lot of records in one transaction or opening a bunch of connections at the same time, you run the risk of encountering various database configuration-related issues. Below are some of the f
Building with Oracle XML Database
(Magnús Kristjánsson) As a software development shop involved with XML technologies for several years, Theriak Software (formerly eMR) has witnessed firsthand the many recent improvements Oracle has made in these technologies. This article explores some of the techniques we used to successfully buil
Designing your Application to Reap the Benefits of Lower Isolation Levels
(Derek Williams) In the Volume 10, Number 3 issue of IDUG Solutions Journal, John Lynch and Yong Ju Li described performance improvements that came from changing to a lower, uncommitted read (UR) isolation level. Their results were so dramatic, they referred to them as paradise found. These prom
Display the PL/SQL Dependency Tree
(Casimir Saternos) As PL/SQL a code base for an application grows over time, the number of dependencies that exist can grow and become difficult to manage. This can be especially difficult for the DBA being called upon to support a legacy system that has had numerous independent developers contr
Parsing XML documents with Perl’s XML::Simple
As more and more Web sites begin using XML for their content, it’s increasingly important for Web developers to know how to parse XML data and convert it into different formats. There used to be two ways of doing this: setting up callback handlers that get invoked when a particular element type is r