(Vivek Sharma) There are various reasons that can cause a query to have multiple child cursors causing severe latch contention at the database level. One of these is optimizer_mismatch.
Other News
How Oracle Really Works (26) – The Cost-Based Optimizer Part 1
(Donnie ‘Dean’ Reynolds) The Oracle Cost-Based Optimizer (CBO) is an optimization engine. What that means is that it tries to find the best way to give you what you want.
Mastering Ajax, Part 11: JSON on the server side
(Brett McLaughlin) In the last article, you learned how to take an object in JavaScript and convert it into a JSON representation. That format is an easy one to use for sending (and receiving) data that maps to objects, or even arrays of objects. In this final article of the series, you’ll learn how
Transform UML to COBOL with WebSphere Developer for System z, Part 1: Create COBOL programs and Web services without writing code
(Reginaldo Barosa) Explore a new feature in Version 7 of WebSphere Developer for System z: z/OS Database Application Generator. z/OS Database Application Generator automatically generates CICS COBOL programs that can access DB2. It also generates a Web service, as well as the Job Control Language (J
SQL Server Locks
(Buck Woody) This is a topic which can really live in almost any area of the SQL Server Guide here at InformIT. The behavior I’ll describe in this tutorial can be caused by design, programs, administration practices and even – nothing at all. The reason is that locks are an inherent part of a Relati
SQL Server 2005 Express Edition – Part 4 – Surface Area Configration
(Marcin Policht) In the previous article of our series dedicated to SQL Server 2005 Express Edition, we have provided a comprehensive listing of its currently available releases (along with locations from which each of them can be downloaded), distinguished by a number of factors, such as supported
Display hierarchical data in VB.NET with the TreeView control
(Irina Medvinskaya) If you need to show hierarchical data in a tree-like format in VB.NET, you should use the TreeView control. This flexible control allows you to change numerous properties in order to fit your needs. The TreeView control also lets you add nodes and sub-nodes; you have the option o
Is statistics over non-indexed columns updated by index rebuild?
(Tibor Karaszi) Short answer: no.
Styles in WPF
(Ged Mead) If you glanced at my earlier blog item on WrapPanels you may remember that I raised the question as to whether it was really necessary to have so much laboriously repeated detail for the five buttons, i.e.:-
Creating and Designing Report using iReport – Part 2
(Anuva Das) This article is related to my previous article entitled “Creating And Designing Report using iReport – Part 1.” This article explains advanced features such as subreport and crosstab of ireport and how to generate reports using them.