(Raafat Abdulfattah) This example shows how to insert up to 32000 characters in an Oracle CLOB field using ASP code. I’ll be writing another article to demonstrate the insertion of more than that later on. The example should work with Oracle 8,9 and 10g.
Author: SSWUG Research
Implementing Data Quality Through Meta-Data: Part Two
(David Marco) This article is the concluding portion of a two-part series on implementing data quality through meta data. The first installment examined the role meta data can have in the data warehouse model and data acquisition designs for information content and quality. This segment will examine
Weed out poor candidates for database consolidation
(Hilary Cotter) Many dependencies can make a user database a poor candidate for consolidation. It is critical that these dependencies are spotted in advance so you can plan for or work around them. (R)
Search WebSphere Portal Document Manager using WebSphere Information Integrator OmniFind Edition
(Janet Lee) Integrate IBM WebSphere OmniFind and WebSphere Portal Document Manager using WebSphere Information Integrator Content Edition. OmniFind can then crawl, parse, index, and search a Portal Document Manager repository on any number of specified Portal Document Manager item classes.
SQL Server 2005 Support for XML Data Type
(Surekhas) This article discusses the new SQL Server 2005 XML features. The most significant new feature is the ability to store XML documents in the new XML data type and to be able to index, retrieve, query, and modify elements and their attributes using XQuery. Explaining XML its types and uses i
Large Memory Optimization (Big Pages, Huge Pages)
(Jisheng) Big Pages in RHEL2.1 and Huge Pages in RHEL 3/4 are very useful for large Oracle SGA sizes and in general for systems with large amount of physical memory. It optimizes the use of Translation Lookaside Buffers (TLB), locks these larger pages in RAM, and the system has less bookkeeping work
MySQL to Draw Curtain on Older Databases
(James Niccolai) MySQL has published its first “end of life” timetable for its open-source database and will no longer provide free updates for some older versions of the product starting next month.
Improve ODP.NET Performance
(Mark A. Williams) For features and performance, Oracle Data Provider for .NET (ODP.NET) is your best choice for connecting .NET applications with Oracle Database.
z/Data Perspectives: The Basics of DB2 Buffering
(Craig S. Mullins) Memory usage is one of the most important areas for tuning DB2 subsystem performance. DB2 for z/OS uses memory for buffer pools, the EDM pool, RID pool, and sort pools to cache data and structures in memory. The better memory is allocated to these structures, the better DB2 will p
Protect your Web apps from state-based attacks
(Mike Andrews and James A. Whittaker) The Web is “stateless” in the sense that it does not remember which page a user is viewing or the order in which pages may be viewed. This is ideal when browsing for information, but users do more on the Web than surfing static, standalone pages, and statelessne