(Randolf Geist) When I read the recent post by the optimizer group about the new concurrent gather stats feature added in 11.2.0.2 it reminded me of the fact that I intended to publish something based on the same idea already some time ago.
Other News
To RDF or not?
(Norman Walsh) First, a little history. When I started this weblog, I did so in part to experiment with a number of technologies, including RDF. The system I built did use RDF and I was able to leverage benefits from it: combining data from several sources and using inference to generate some metada
Implementing Deletes with Template Event Handlers
(Peter Vogel) Over the last three columns, I built a page with basic updating, deleting, and display functionality using the new templating and data linking functionality in jQuery.
reTHINK Migration – Part I
Very funny animated video on the tale of two villagers who want to break free from the baron’s taxes in the Town of Orrible and flee to the wonderful town of DB2.
What’s this table? SYS_IOT_OVER_152769
(Jeffrey Kemp) I was writing some scripts to drop all the objects in a particular schema on an 11gR2 database, and in querying the USER_OBJECTS view, came across a whole lot of tables with names like this:
Accessing SharePoint 2010 Data with the Silverlight Client Object Model
(Andrew Connell) Learn how to use the Silverlight client object model in Microsoft SharePoint 2010 to read and write data in SharePoint sites from Microsoft Silverlight applications.
SQL Server Service Broker – Internal Activation
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and SQL Server 2008 R2) which allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applica
Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
(Sunil Agarwal) When using NOLOCK hint on the table or using read uncommitted isolation level, customers sometimes get surprised when they experience blocking.
SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28
(Pinal Dave) For any good system three things are vital: CPU, Memory and IO (disk). Among these three, IO is the most crucial factor of SQL Server. Looking at real-world cases, I do not see IT people upgrading CPU and Memory frequently.
Using COBOL copybooks in WebSphere Integration Developer V7
(Marc Fasbinder) In this article, you will define business objects based on COBOL copybook structures and use data bindings for them without having to write code. This article is based on version 7.0.0.3 of WebSphere Integration Developer and WebSphere Process Server.