(Dave Beulke) Talking with people at the DB2 Washington DC-Baltimore user group meeting was very interesting. Surveying the group showed that everyone was planning to perform DB2 migration to DB2 10 as soon as possible. Everyone was excited about the DB2 10 performance features and especially the co
Other News
Controlfiles : Number and Size
(Hemant K Chitale) A forums thread “Maximum number of Control Files” allowed me to express my opinions about why, for very practical reasons, Oracle does not allow very many multiplexed copies of the controlfile and why the controlfile is “limited” in size.
Integrate Blogger content with PHP applications using the Blogger Data API
(Vikram Vaswani) Blogger is a free, popular blogging platform that lets users create their own weblogs, and post messages and news, through a WYSIWYG editing interface. With the Blogger Data API, which is REST-based, you can access Blogger content through any XML-compliant programming toolkit.
Batched Key Access Speeds Up Disk-Bound Join Queries
(Øystein Grøvlen) A new feature in MySQL 5.6.3 Development Milestone Release is Batched Key Access (BKA). BKA can be applied when an index lookup can be used to execute a join query. One example of such a query is:
Transferring Data from a Single XML Stream into Multiple Tables with One Forward-Only Read
(Rob Lyndon) Data transfer is a very common business process. Most developers are familiar with finding ways of taking data from a remote source and writing it to a local database. It is often possible, and even appropriate, to load the remote data into memory and then write it to your database usin
Data Types of the Future!
(Bill Lewis) Our topic for this article is one of the most fascinating and leading-edge issues on the data management scene: data types! Well, maybe not yet so fascinating and leading-edge…but it may well be in the near future.
C# Sizeof Keyword
In some situations it is necessary to know the size of a value type, such as a built-in numeric data type or a custom structure. The number in bytes can be looked up or calculated, or the sizeof keyword can be used to automatically obtain the size.
SQL Server: Removing Deprecated Code and Future Proofing your Queries
(Suprotim Agarwal) New features are added with every release of SQL Server and as a result, some features get removed or deprecated. Deprecated features are features that are still operational (for backward compatibility) but will be removed in a future version. Deprecated features can be of two typ
MDX Descendant Function
(Karan Gulati) This example shows how to use Descendant function with Desc_Flag as self_before_after which means this will show all members at level – Subcategory_Category_Product. and to prove that we are getting correct result I am using Member Property – Level which shows Level Name to which Memb
Does Clustered Index physically orders the data within a table?
(Vadivel) Quite a lot of time I have come across people saying “Clustered Index Physically sorts the data inside the table based on the Clustered Index Keys”. It’s not completely true!