(Navneeth Diwaker Naik) One of the best features of SQL Server 2000 is its user-defined functions (UDFs). UDFs offer many of the benefits of both views and stored procedures, and more.
Other News
Publishing SQL Server in Active Directory
(Chad Miller) If you’ve noticed the Active Directory tab under SQL Server Properties in Enterprise Manager, you might have wondered how Active Directory (AD) relates to SQL Server and what the benefits are of adding SQL Server and its databases to AD. Network services such as file and printer server
Import Multiple Files to SQL Server Using DTS
(Muthusamy Anantha Kumar) In the typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to import many files at the same time from same or different folders. In my previous article, I mentioned how to import such files using BULK Insert and
Query Designer Considerations for Oracle Databases
If you are creating queries using the Oracle database server, you can take advantage of features specific to that server. The following guidelines outline differences you will notice in the Query Designer when you work with the Oracle Server, and provide information about Oracle-specific features th
The Range-clustered Table: A New Kind of Table in DB2 UDB V8.1.4
(Paul C. Zikopoulos and Roman B. Melnyk) This article outlines range-clustered table (RCT) support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. RCTs represent a new table type that is supported through the ORGANIZE BY KEY SEQUENCE clause on the CREATE TABLE statement.
Database expert will steer Collaboration Suite
(Robert Westervelt) Oracle is bringing back Terry Olkin, a former Oracle database executive who founded the company’s advanced technology division, to be the chief architect of the company’s Collaboration Suite. That move could signal a major advancement for the software suite, analysts say, though
INFO: DB2OLEDB Supports UPDATE/DELETE from SQL Linked Server
The Microsoft OLE DB Provider for DB2 (DB2OLEDB) that ships with Host Integration Server 2000 or SNA Server 4.0 Service Pack 4 supports SELECT, INSERT, UPDATE, and DELETE statements from SQL Server Linked Server.
A Practical Guide to Data Warehousing in Oracle, Part 4
(Dave Aldridge) On a regular OLTP system, one of the perennial sources for doubt and debate is the number, type and configuration of indexes, and for good reason. An OLTP system generally runs with some limited set of select queries and a range of updates, inserts, and deletes. A balance has to be s
XML Schema 2nd Edition
(Rick Jelliffe) The W3C XML Schema Working Group has published the second edition of the three parts to XML Schema. This is a housekeeping edition. The changes of note in the XML Schemas Second Edition seem to be: –Some examples in the Primer are simplified, –The Schema for Schemas is mo
DB2 for z/OS Stored Procedures: Through the CALL and Beyond
(Paolo Bruni) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and ope