After you upgrade to SQL Server 2000 Service Pack 3, the SQL Server query optimizer may incorrectly estimate the cost for queries that involve a predicate that uses a NOT EXISTS () construct. The estimate will be too high, and results in poorly performing queries as compared to SQL Server
Author: SSWUG Research
Cross Broswer Display of XML/XSL
By David Silverlight – This snippet is a very simple example that uses ASP to merge the XML/XSL server side and displays the output as pure HTML instead of XML. This will work will for non-IE5 browsers.
Advanced Type Mappings
Can XmlSerializer deal with choice compositors? How about mixed content models? XmlSerializer won’t serialize objects that implement IDictionary by default, so how do you get arount it? And more.
Oracle, Plumtree target Sarbanes-Oxley
By James Niccolai – Oracle will release a new application in the coming weeks designed to help companies comply with the Sarbanes-Oxley Act of 2002, a set of corporate disclosure and financial reporting rules for companies that are traded publicly in the U.S., the company said Wednesday. Meanwhile,
BMC updates management tools for DB2
By Stacy Cowley – BMC Software plans to soon release new versions of two applications for managing IBM’s DB2 UDB (Universal Database), making available to DB2 users features already out for those working with Oracle’s database software.
MDX in Analysis Services: Intermediate Concepts – Part 2
Join Bill Pearson as he further develops intermediate concepts using MDX in Analysis Services. In this tutorial, Pearson works with hierarchical relationships in leveraging MDX to meet analysis needs.
Testing a connection from Visual Basic 6.0 to SQL Server
I want to test a connection from Microsoft Visual Basic version 6.0 to SQL Server. I tried to conduct the test through the SQL-DMO VerifyConnection property but was unsuccessful. Listing 1, which follows, shows the code I used. Where did I go wrong?
Plugging in to Faster Data Access
By Victor Alvarez – As it matures with each release, DB2 provides faster distributed data access. Changes in version 8 take it to a whole new level.
Developing Database Projects for z/OS in Visual Studio .Net
This tutorial demonstrates the use of the DB2 database project template of the IBM DB2 Development Add-In to create tables, indexes, views, triggers, and stored procedures for a DB2 for z/OS database.
How to troubleshoot connection problems
By Alexander Chigrik – Should you have connection problems, review this troubleshooting checklist to find potential solutions.