(Willie Favero) A little over 4 years ago, I did a blog post giving my opinion on what your DB2 maintenance strategy should be.
Other News
XML Serialization of Arrays and Collections
Arrays and collections can be serialized to XML. The standard action when using the default serializer is for the name of the collection property to be added to the XML, with a contained element for each item named according to the items’ data types.
OBIEE: Breaking Stuff
(oraclenerd) A conversation with some colleagues the other day prompted some more research on my part on what exactly would break when making changes to the Presentation (metadata/RPD) layer in OBIEE.
ORA-20001: Error in multi row delete operation: row = nnn, ORA-1403, no data found. Error in multi row operation failed
(Flavio Casetta) Ever encountered the following error when attempting to delete one or more rows in a tabular form report?
Logical I/O – Evolution: Part 1 – Baseline
(Randolf Geist) This is the first part in a series of blog posts that shed some light on the enhancements Oracle has introduced with the recent releases regarding the optimizations of logical I/O.
On Covering Indexes and Their Impact on Performance
(Ovais Tariq) The purpose of this post is to describe what covering indexes are and how they can be used to improve the performance of queries. People mostly use indexes to filter or sort the results but not much thought is given to actually reduce the disk reads by using proper indexes.
Performance impact: too many try/catch blocks may be harmful in SQLCLR
(Linchi Shea) If you have many try/catch blocks in your .NET code and your code execution actually passes through them, you should expect a performance hit. That’s intuitive and no surprise.
Emulating Records and Collections via CLR UDT
(Bill Ramos and Vishal Soni) This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating Oracle Records and Collections.
Create Documentation for SQL Server Tables
(Alexandros Pappas) This post presents a tool that creates a Word document that contains the schema information of the tables in a SQL server database.
Anonymous Typed Classes in C#
(Abhimanyu Kumar Vatsa) Anonymous types provide a convenient way to encapsulate a set of read-only properties into a single object without having to explicitly define a type first. The name is generated by the compiler and is not available at the source code level or our application cannot access it