(Martin Hansson) Now that the cost model project is progressing, most of you are going to notice execution plan changes. In the vast majority of the cases, the changes will be for the better, and some bugs with a long history will finally be closed.
Other News
Workaround for ADF 12c Choice List Blank Selection Issue
(Andrejus Baranovskis) I would like to share a workaround for Choice List component in ADF 12c. There is specific issue, related to blank selection – as soon as user selects blank selection in the choice list, it starts to invoke value change listener for that list, each time when any other element
Latest Oracle allows SELECT without SELECT…FOR UPDATE
(Gary Myers) Digging through a backlog of Oracle blogs, I came across an gem in a presentation from AMIS (on Slideshare). Got to bullet point 5 on slide 63 and boom!
JDeveloper ADF: How to add Table Footer Totals
(Jose J. Sanchez) Do you want to add the total of a column to a at the bottom or footer?
Software that Writes Software
One of the most difficult kinds of software I have worked on is where you use data to define or logic. One kind of program you could write uses meta-data stored in a relational database to write and execute SQL code based on what it finds. I once created a stored procedure that would identify the structure of a table […]
Tips for using Join Hints in SQL Server 2014
Tips for using Join Hints in SQL Server 2014 Use join hints very carefully. Because SQL Server 2014 query optimizer usually proposes the best execution plan, it is very unlikely that you can optimize your query by using join hints, more often, this will hurt performance. Try to rewrite the query to provide better execution plan. If your query is...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Options to Encrypt Data at Rest in DB2
(mkrafick) I thought it would be relatively easy to investigate encryption for our environment. I was wrong, was just plain confusing. This was not because encryption is complicated per se, but that a DBA really needs to have a good understanding of business needs. If you don’t have this understandi
IBM or Drools/Red Hat JBoss BRMS – Whose Rules Rule?
(John Santoro) By automating critical business decisions, a Business Rules Management System (BRMS) can increase the productivity, consistency, and quality of your most important business processes. To realize these benefits, a BRMS must make it easy to capture your company’s expertise as rules, mus
#0349 – SQL Server – SSMS Usability – Unable to Show XML, Unexpected End of File when parsing
(Nakul Vachhrajani) Today’s post comes from a recent experience. I was trying to extract an XML from one of the logs that we maintain in the application when exchanging data over an interface. The XML was coming from a table and I had written a simple SELECT statement similar to the one shown below:
Increase throughput with z/OS Language Environment heap storage tuning method
(Terry Borden, Greg Dyck, Nicholas Matsakis, Zhuang Lei, Wu Hao, Chunxin Yang and Xuelian Zhang) The z/OS Language Environment (LE) component provides a common runtime environment for the IBM version of certain high-level languages. LE provides runtime options that can be customized according to th