(Sam Vanga) There are a few design choices that can make your SSIS packages run super fast when loading data from table A to table B.
Other News
generate_series for SQL Server 2008
(Simon Greener) I recently wrote an article about implementing the PostgreSQL function, generate_series, in Oracle.
Top 10 Reasons to Consider DB2 10 for LUW
(Vijay Sitaram) It seems like yesterday when we took the wraps of DB2 V9.7 for LUW. I admit it is a kid in the candy store moment every time I get my hands on a newer version of DB2. The new features and enhancements in this new release address the needs of our business, directly improving availabil
COMMIT_WAIT and COMMIT_LOGGING
(Christian Antognini) Recently I used the COMMIT_WAIT and COMMIT_LOGGING parameters for solving (or, better, working around) a problem I faced while optimizing a specific task for one of my customers. Since it was the first time I used them in a production system, I thought to write this post not on
How Statistics Have Improved from Oracle 10gR2 to 11gR2
(David Fitzjarrell) Oracle databases run better with a good set of statistics, and by good I mean representative of the data distribution or skew. Oracle did its best in earlier releases of the database to ensure statistics were accurate but changes in the optimizer behavior and in the data we store
VIDEO: The IBM Perspective on DB2
Chris Eaton of IBM discusses why you should consider migrating from Oracle to DB2.
Can COUNT(*) be used in MySQL on InnoDB tables?
(Thomas) COUNT() function returns a number of rows returned by a query. In a popular opinion COUNT(*) should not be used on InnoDB tables, but this is only half true.
Getting the most out of the SharePoint Community Calendar Part 1
(Raymond Mitchell) For those of you that didn’t already know – the SharePoint community is incredibly active. This week alone there are 25 events going on that I know of! Even more amazing is that many of these events are freely available User Groups, SharePoint Saturdays, and webcasts.
Parsing, Traversing, And Mutating HTML With ColdFusion And jSoup
(Ben Nadel) Earlier this week, James Moberg asked me if I had ever used the jSoup HTML Parser with ColdFusion. Until then, I had never even heard of it; all of my experimentation with HTML parsing in ColdFusion has been done with TagSoup.
Innovations within reach: Elastic cache beyond the Java heap with IBM eXtremeMemory
(Charles Le Vay and Thomas Gissel) The 7.1.1 release of IBM WebSphere eXtreme Scale introduces an additional in-memory model for elastic caching called IBM eXtremeMemory, which enables you to utilize the system memory outside of the Java heap as elastic cache. This allows for smaller Java heap sizes