(John Hallas) Problem Statement: rdbms version 11.1.0.7 – HPUX
Other News
Merge XML files into a PDF Document in .NET
(Azam Sher) Sometimes different PDF documents have some content in common. For example, a number of PDF documents may have the same header or footer. In such cases, .NET developers who are responsible for document creation might go through a lot of code duplication. To reduce this code duplication,
I/O for OutOfLine LOBs
(Hemant K Chitale) When you define a LOB (CLOB or BLOB) as a column for a table, you have the choice of specifying whether it is Inline (stored with the row) or OutOfLine (stored in a separate segment).
Oracle Index rebuild online – 10g Vs 11g
(Advait Deo) An index is basically used for faster access to tables. Over a period of time the index gets fragmented because of several DMLs running on table.
Data Studio and DB2 for z/OS Stored Procedures
(Paolo Bruni and Marichu Scanlon) Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered ever-improving support for developing and operating stored procedures.
Query SQL Server with PowerShell
(Joshua Jones) Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you’re probably asking yourself, “Now that I have it, what do I do with it?”
SQL Server Integration Services (SSIS) -Import Data using Wizard
(Karthikeyan Anbarasan) In this article we will see how to import data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio). Using SSMS we can perform many tasks like copying data from one server to the other or from one data source to the other in a variety of
Storage provisioning in Informix
(Aniket J. Adnaik and John C. Lengyel) Storage provisioning, a new feature in IBM Informix 11.7, makes storage management much easier. With this new functionality, DBAs don’t have to monitor Informix in order to anticipate when an application might deplete storage. Now Informix can automatically all
How to Identify Memory Bottlenecks in Microsoft SQL Server
(Tibor Nagy) We experience regular slowdowns on our MS SQL Server database. We would like to start the root cause investigation by examining memory bottlenecks. What is your recommendation to uncover memory bottlenecks in SQL Server?
JQuery – Browser Equalizer
JQuery – Browser Equallizer We have been considering how to handle code unique for different brands and versions of browsers for the last couple of days. Some of the things I have been looking for were testing techniques, ways to reduce the number of tests necessary, and software frameworks to reduce coding. A number of tools and techniques were submitted […]