(Dave Beulke) Writing good DB2 SQL is always difficult because it is dependent on the database table design and the various table indexes available coming together with the purpose of the processing module.
Other News
Externally Stored Fields in InnoDB
(Annamalai Gurusami) This article discusses the storage (inline and external) of field data in the InnoDB storage engine. All fields of variable length types like VARCHAR, VARBINARY, BLOB and TEXT can be stored inline within the clustered index record, or stored externally in separate BLOB pages out
ADF 12c (12.1.3.0.0) – View Object Declarative Mode is Default
(Andrejus Baranovskis) Important event for ADF community – new release of ADF 12c (12.1.3.0.0). Quite many new features overall in the framework and there are some related to ADF BC. I will focus on ADF BC and highlight one new feature, which I think is very important to know.
Exadata: When A Smart Scan Isn’t
(David Fitzjarrell) Exadata is a powerful system, able to provide exceptional performance. Much of this peformance is due to Smart Scans, Exadata’s mechanism for shifting the workload to the storage cells and having them filter and reduce the amount of data the database servers must process.
IBM DB2 with BLU Acceleration
(Whei-Jen Chen and Shawn G. Tooley) Available with the IBM DB®10.5 release, BLU Acceleration delivers unparalleled performance improvements for analytic applications and reporting using dynamic in-memory optimized columnar technologies.
Understanding UNDO
(Jay Stanley) Sooner or later, every Oracle DBA will hit a problem of some sort that is related to the concept of Oracle “Undo”. The Oracle Undo performs a few very important functions in the database; these being the support of read-consistent queries and Flashback queries, supporting transactions
WPF Menu Controls – ToolBar
(Richard Carr) The seventy-ninth part of the Windows Presentation Foundation Fundamentals tutorial describes another of the WPF menu controls. This article looks at the ToolBar class, which presents a series of commands, usually as a strip of small buttons.
How to Use XML File to Store Data and Retrieve Data Using ASP.Net With C#
This article explains how to use a XML file to store and retrieve data dynamically using ASP.NET with C#. This article will also help to create child nodes in a XML file using ASP.NET.
Introduction to ASP.NET MVC6
(Vipul Patel) In an earlier article, Introduction to ASP.NET vNext, we learned about the next generation of ASP.NET called ASP.NET vNext.
SQL SERVER – SSMS: Scheduler Health Report
(Pinal Dave) Have you ever been to a music concert? It is the most humbling experience one can get as a music lover. The live music with hundreds of musicians in one stage brings goosebumps with the very thought. I have always been fascinated and wanted to experience this once in a lifetime and am s