(Gokhan Atil) Real data often shows correlations between column values. Because the optimizer does not know these real-world relationships, it will have difficulty estimating the cardinality and may pick sub-optimal execution plans for your queries.
Other News
The exceptional case of the backwards null
(Gary Myers) Yes, Virginia, there is a unique NULL. The trick is to go backwards.
The DB2Night Show #Z07: Top DB2 e-Communities, Blogs and networking tools
(Klaas) In episode #Z07, special guests Surekha Parekh (DB2 for z/OS Marketing Manager), Susan Visser (Program Manager Publishing) and Willie Favero (Writer, Speaker, Teacher, Technician, DB2 Enthusiast, and DB2 SME) show us the wonderful world of e-communities and blogs.
A Note on DB2 for z/OS ‘Conditional GETPAGE Failures’
(Robert Catterall) Recently, a DB2 for z/OS professional asked me about something he’d occasionally seen in a DB2 monitor display: a non-zero value for CONDITIONAL GETPAGE FAILURES for a buffer pool.
Free Aggregate Method for Concatenating 2D Lines in Oracle Locator 10g
(Simon Greener) The SDO_AGGR_CONCAT_LINES function in Oracle 10g and above allows for linestrings to be concatenated via GROUP BY SQL clauses.
10 Things to Collect for SQL Server Inventory
(Claire Hsu) Server inventory is essential for SQL Server DBAs. It comes in handy when you are trying to get yourself familiarized with a particular SQL Server instance, collecting information before a server migration/upgrade project, preparing for business continuity procedure (BCP) testing, or re
How to Reset a SQL Server sa Password
(Steven Smith) If you need to reset the sa (system administrator) password on a MS SQL Server database because you’ve lost or forgotten the old password or you’ve change your active directory domain, you can do so provided that you can access the server with an account that has local administrator p
Working with User Models in PHP and MySQL
(Alejandro Gervasio) Being one of the big pillars of Object-Oriented Design, The Interface Segregation Principle (ISP) permits you to define fine-grained contracts that provide client classes with the functionality to perform a set of well-defined tasks.
LINQ Partitioning with Indexes
The LINQ partitioning operators allow the first elements of a sequence to be extracted, or skipped so that all other elements are returned. When using TakeWhile and SkipWhile, the index of each item can be included in the predicate.
Turning any XML document into a Java Object graph using JAXB 2.0
(Lucas Jellema) As a followup to my recent article on how to Produce and XML document based on data in a POJO structure using JAXB (http://technology.amis.nl/blog/12499/creating-an-xml-document-based-on-my-pojo-domain-model-how-will-jaxb-help-me) I will describe in this article how to go the reverse