(Willie Favero) A friend recently ask me about DSNDB01.SPT01, compression and DB2 10. It seems like some folk said there would be no need to compress SPT01 once you migrated to DB2 10 because DB2 10 uses LOBs with SPT01.
Other News
METHOD_OPT => SIZE AUTO Quiz (Automatic For The People)
(Richard Foote) OK, a nice, easy, simple one today. No tricks, honest.
IMPDP creates indexes with parallel degree 1 during import
(Marko Sutic) Last few days I’ve been playing with export and import of 750 GB database. During this whole trial and error process I’ve learned several things that were unfamiliar to me. In this blog post I want to share some of the stuff that I learnt.
Not All Data Compression Is Created Equal
(Denny Cherry) While we like to say that storage is cheap, but the reality is that cheap is relative. If you don’t have budget for more storage, suddenly storage isn’t very cheap.
SQL Server Index Statistics
(Greg Larsen) Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table.
Three Essential DB2 Temporal Table Index Performance Design Points
(Dave Beulke) There are many design aspects for DB2 Temporal Tables that I have discussed in some of my previous blog entries. While reviewing the design of a recent data warehouse system, it became apparent that many index design points weren’t evaluated and were causing overall poor application pe
Practical Multi-Master Replication using Shard Filters
(Robert Hodges) Earlier this month I published an article on this blog describing the system of record approach to multi-master replication. As mentioned in that article my colleagues and I at Continuent have been working on improving Tungsten to make system of record design patterns easier to impl
Distributed DBA: Automatic storage databases
(Roger E. Sanders) Table spaces have long been used to provide a layer of indirection between database objects (tables, indexes, views, and so forth) and the storage containers (directories, files, or raw logical volumes/disk partitions) where data physically resides.
Making SQL Work Too Hard
Making SQL Work Too Hard I was reading a forum and came across a question where someone wanted to take a query returning 30 columns and break them out into three lines of 10 columns each. I really enjoy these kinds of challenges from the standpoint of how to write SQL to accomplish this task. I have been using SQL […]
Feedback on Usability
Feedback on Usability Interesting feedback on the issue of Usability. For me, usable means that software is efficient (lets me accomplish my task in the most efficient way possible), intuitive, and has the right features. Believe it or not, that is a lot to ask of software. It is even more to ask when you have a large user base […]