(Paul McInerney and Danny Zilio) Get expert help with designing data partitioning keys, materialized query tables, and multidimensional clustering for IBM DB2 Universal Database (DB2 UDB), in addition to indexes. The Design Advisor offers the help you need and is built right into DB2 UDB. Part 2 of
Other News
Fire up your merge replication performance
(Hilary Cotter) The best way to improve merge replication performance is to run merge agents as frequently as possible. However, if your Subscribers are offline, running merge agents will not always be possible, and you should urge users to synchronize frequently instead. The following tips will hel
The blocked column in the sysprocesses table is populated for latch waits after you install SQL Server 2000 SP4
After you install Microsoft SQL Server 2000 Service Pack 4 (SP4), you may notice that the blocked column in the sysprocesses system table is populated for latch waits in addition to lock waits. Sometimes, you may notice brief periods of time when a single server process ID (SPID) is reported as bloc
Exporting a DB using Oracle Console
(Maria Anderson) I’d like to ask how I can export my DB using Oracle Console. It asked me to log in in management server mode but I cannot log in. I gave the server as my DB name and it told me that there is no such server. When I log in as SYS, it tells me that you have […]
IBM to Unwrap New Notes and Domino Version
(Lee Kroon) IBM will officially unveil Version 7 of its Lotus Notes and Domino family of products. Though the much-anticipated software will build upon the technologies that Notes customers have long used, it will also offer increased integration with IBM’s DB2 and Workplace products. That integrati
Introduction to Microsoft .NET
(Vidya Vrat) The .NET Platform consists of a set of technologies and tools designed to simplify development of distributed applications, including Windows applications, Windows services, console applications, and Web services. The .NET Platform also helps you to build applications using a collection
SCO, MySQL Bring MySQL to OpenServer
(Steven J. Vaughan-Nichols) SCO and MySQL announced Friday that the two would be working together to jointly deliver the commercial version of the MySQL database to SCO’s latest Unix release, OpenServer 6.
SAP Chips Away at Oracle Fusion Strategy
(John Pallatto) Opinion: Oracle competitor SAP is buying a third-party PeopleSoft support provider to build its own potential captive market.
Building Data Mining Solutions with OLE DB for DM and XML for Analysis
(Zhaohui Tang, Jamie Maclennan and Peter Pyungchul Kim) A data mining component is included in Microsoft SQL Server 2000 and SQL Server 2005, one of the most popular DBMSs. This gives a push for data mining technologies to move from a niche towards the mainstream. Apart from a few algorithms, t
XML Indexes in SQL Server 2005
(Bob Beauchemin) Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.