(Anghel Leonard) Check out this practical code guide on converting between Date and Temporal classes in Java.
Other News
Db2 Web Query Lives On (Just Not V2.1)
(Alex Woodie) There have been some rumors that IBM is going to sunset Db2 Web Query for i, or replace it with Cognos. Neither of those rumors is true, according to IBM, which recently made some changes to Db2 Web Query support.
MySQL Document Store – a quick-guide to storing JSON documents in MySQL using JavaScript and Python (and even SQL!)
(Tony Darnell) MySQL introduced a JSON data type in version 5.7, and expanded the functionality in version 8.0.
Predict_Clustering_Factor
(stewashton) Jonathan Lewis recently wrote about estimating the clustering factor of an index, taking into account the intended value of the TABLE_CACHED_BLOCKS parameter of DBMS_STATS.SET_TABLE_PREFS.
Turning your Raspberry Pi into a science research station via BOINC
(Gerald) BOINC lets you help cutting-edge science research using your computer (Windows, Mac, Linux) or Android device. BOINC downloads scientific computing jobs to your computer and runs them invisibly in the background.
Connect to ActiveDirectory with ldapsearch on Unix
(Laurent Schneider) In ancient times, ldapsearch could query ActiveDirectory without issues. In this examples, I used openldap client 2.4.
SQL Server Implicit Conversions Performance Issues
(K. Brian Kelley) I’ve heard implicit conversions in T-SQL code are bad for SQL Server performance, but I don’t understand how and when they occur. I also don’t know how to detect if they are occurring in my SQL Server queries. Can you explain what they are and how I might spot them?
Alphabetical Search Using Ajax In ASP.NET MVC
(Farhan Ahmed) In this article, I will explain to you how you can create alphabetical search and pagination using jQuery Ajax in asp.net MVC.
Prior to DBMS, Database Approach, Data Model — Part 5
Data Abstraction Layer In an illustrated view, an individual can understand in what way the dissimilar models work together. Consider this from the highest level, the external model. The external model is the view of the end user data. Generally, a database is a business system that meets the needs of numerous services. On the other hand, a service 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
The Eager Index Spool and The Optimizer
(Paul White) An Eager Index Spool reads all rows from its child operator into an indexed worktable, before it starts returning rows to its parent operator. In some respects, an eager index spool is the ultimate missing index suggestion, but it is not reported as such.