The Sqlfstin.exe sample demonstrates how to perform quick, transactional inserts of a large number of records into SQL Server by using the IRowsetFastLoad interface and the ATL OLE DB consumer templates. The sample also shows how to roll back such transactions.
Other News
SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++
XMLTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML Template file and the ADO Command object.
J2EE Classloading Best Practices
(Debu Panda) Here are some common classloading best practices that we have been following and hope useful to many.
Overview of Performance
(Leo Peysakhovich) There are bunches of articles and books about database’s, application’s, and other types of performance. I would like to overview some interesting aspects related to the subject of performance or Transact SQL behavior in batch processes and in stored procedures. (R)
Basic IDS architecture and tuning
(Jianining Fan) It is important for an Informix DBA to be familiar with basic IDS architecture; it gives broader and deeper insights into the database server and helps in daily database administration work such as troubleshooting, monitoring and fine tuning a database engine for better performance.
Retrieve Specific Nodes When They Contain an xmlns Namespace Parameter
When an XML file contains a xmlns parameter, you can’t use simple SelectSingleNode to retrieve a specific node. Take the following code, for example.
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Caching and Additional Techniques
(William E. Pearson, III) In this article, we will continue our examination of MDX optimization techniques, begun in the article prior to the last, MDX Optimization Techniques: Introduction and the Role of Processing, and continued in the last article, MDX Optimization Techniques: Further Control of
Inventorying hardware and OS information on all SQL Servers
(Muthusamy Anantha Kumar) Whenever database administrators begin new jobs or to administer and manage new SQL servers, the first step is to take inventory of the server. This includes information like Operating system, Service packs, physical memory, virtual memory etc. In this article, I explain ho
Lessons Learned: Configuring RAID
Welcome to SearchOracle.com’s Lessons Learned series. Each week you will get a mini-lesson pertaining to a highly-specific database administration, application development, data warehousing and business intelligence, or E-Business Suite topic. At the end of each month, you will be tested on what you
Remote administration with DAS
(Thomas Bauch and Mark Wilding) The DAS process is a separate DB2 process for managing local and remote DB2 servers. The DAS process is used by the DB2 administration tools, including the Control Center and the Configuration Assistant, to satisfy requests. The db2admin commands allow you to start, s