(Martin Widlake) In my last post, IOT part 6, inserts and updates slowed down, I made the point that IOT insert performance on a relatively small Oracle system was very slow, much slower than on a larger system I had used for professional testing. A major contributing factor was that the insert was
Other News
Improvise your Backup-Restore
(samkumar) Somehow I am managing to keep-up with my busy office life and on call support… Which it seems is literally 24X7…
DB2 10- Justifying the Upgrade
(Laura) In his recent webcast, Julian Stuhler looked at the financial justification of migrating to DB2 10 for z/OS.
Evil things are happening in Oracle
(Tanel Poder) Relax, I’m talking about the Oracle Database kernel here, not the corporation 😉
Finding PostgreSQL temporary_file problems with tail_n_mail
(Greg Sabino Mullane) PostgreSQL does as much work as it can in RAM, but sometimes it needs to (or thinks that it needs to) write things temporarily to disk. Typically, this happens on large or complex queries in which the required memory is greater than the work_mem setting.
SQL Server-Hadoop highway to big data ventures into new territory
(Robert Sheldon) Microsoft has made little secret of its move into the realm of “big data” — particularly the massive sets of unstructured files that companies like Google and Yahoo have been grappling with since their inceptions. Google, for instance, processes 20 petabytes (20,000 terabytes) of d
Debugging Tools for the .NET Developer
(Peter Vogel) Bugs occur at two stages in a code’s life: during development and in production. Development bugs are usually easier to track down because, generally speaking, those bugs are related to code you’ve written recently (probably in the last hour).
A Generic Circular Buffer
A circular buffer is a type of fixed size, first in, first out queue. The spaces in the buffer can be thought of as connected in a ring. Items in the buffer are never moved. Instead, changeable pointers are used to identify the head and tail of the queue.
Implementing ASP.NET 4.0 Page.MetaDescription Property
ASP.NET 4.0 offers the meta description property. It can help you tell searchers what they’ll find on your web pages, and possibly increase your traffic. This article shows you three ways to implement this property.
SQL SERVER – Video – Performance Improvement in Columnstore Index
(Pinal Dave) I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were not able