(Prashanth Jayaram) The following query lists all the Primary keys of all the table.
Other News
How Did They Make That???
(David Dye) Often you may run across a stored procedure, view, or function that peeks your curiosity and you REALLY want to see how it works. This is even true of system objects. There are several ways of provinding the text to these objects using T-SQL.
Aggregate APPEND Islands and XOR polygons
(Simon Greener) Aggregation of independent island polygons using sdo_aggr_set_union, sdo_util.append, sdo_geom.sdo_xor, and custom functions.
Better Performance for JOINs Not Using Indexes
(Jesper Krogh) In some cases it is not possible to use an index to optimize a JOIN. This may for example happen when you query the Performance Schema. As a result these kind of queries can be very slow; however in MySQL 5.6 and later you can use a trick to improve the performance considerably.
6 Reason Why DB2 LUW Fix Pak 4 ‘Cancun’ Is So Important
(Dave Beulke) The new DB2 LUW Fix Pak 4 code named “Cancun” was recently released for DB2 LUW Version 10.5. IBM has done a lot of work and put a number of impressive features in this DB2 LUW Fix Pak 4.
Troubles Are Out of Reach With Instant Insights
(Radha Gowda) Bet you have been hearing a lot about shadow tables in DB2 “Cancun Release” lately. Umm… do shadow and Cancun remind you of On the beach by Cliff Richards and the Shadows? Seriously, DB2 shadow tables can make you dance to a rock ‘n’ roll on the beach because you will be trouble free
Quick Tip: Dexterity Ranges and how to update Fields that are part of the Key
(David Musgrave) Last week, I had an interesting case where a Dexterity Developer was having trouble getting some code to update a range of records selected in a table. The code would only update the first record in the range.
How IBM PureApplication System uses DNS to deploy workloads onto the data center’s network
(Bobby Woolf) IBM PureApplication System uses DNS to locate resources on the network so that it can connect to them. This article describes how PureApplication System uses DNS, what queries it expects DNS to be able to answer, what happens when the system can’t use DNS properly, and more.
Layout Managers in Java : Part 3
(Gopi Chand) This article explains the Box and Group layout managers in Java.
Managing the size of the SQL Server SSIS catalog database
(Brady Upton) I have implemented the SSIS catalog that comes with SQL Server 2012 and I love the reporting and centralization that comes with it, however, I noticed after a few months that the database was growing exponentially. How can I keep the size of this database to a minimum?