(Hemant K Chitale) It is a common [mis]understanding that creating a new Index that is a subset of an existing Index is an unnecessary overhead. The argument goes "if you have an Index on (A,B,C) this Index can be used to satisfy queries where predicate ‘A’ is specified, so creating an additional In
Other News
‘Remember to flush’ – Your options in DB2
(Henrik Loeser) When I hear the word “flush”, I always have to think about the movie “The Man Who Knew Too Little” and the scene where Wallace/Spenser is told “Remember to flush”.
MySQL 101 – Changing data and schema, UPDATE, ALTER
(Adam Donnison) In our last episode we covered sorting, searching and grouping. We found out that using the COUNT(*) can be problematic when we have unexpected NULL data. Now we look at how to resolve data issues by updating the data, and perhaps even the table schema. We’ll use the same database we
Asynchronous Tasks and Synchronization on UI TPL .Net 4.0
(Amit Choudhary) Using TPL for parallel programming is now a cup of cake. It made life easier for those who are new to multithreaded programming. A bunch of code lines can be encapsulated as an individual task using the Task class and you have the flexibility to run the task in either Sync or Async
SQL Server performance tuning for each layer of an application
(Brady Upton) Performance is always a key factor when using SQL Server and should be thought about before the initial setup of the server as well as when the application is being used in production. In this tip I cover the approach I like to take when setting up and tuning my SQL Server environment
GEOPROCESS Java class compilation for 11g and above
(Simon Greener) Java classes loaded into the Oracle JVM are interpreted when executed up to and including Oracle 10gR2. For Oracle 11g and upwards, these loaded Java classes can be compiled to native code.
Writing a Recipe for ASP.NET MVC 4 Developer Preview
(Phil Haack) Last week I spoke at the //BUILD conference on building mobile web applications with ASP.NET MVC 4. In the talk, I demonstrated a recipe I wrote that automates the process to create mobile versions of desktop views.
Document formats, part 3: Changing formats
(Evan Lenz) I ended the last installment with this question: What happens if you load a bunch of HTML documents as “text” and then realize you want to query them as XML (using the full power of XPath and XQuery)? In this article, I’ll show you exactly how I solved this problem (and how you can too).
http://it.toolbox.com/blogs/db2zos/db2-10-for-zos-can-ziip-ziip-ziip-and-even-ziip-48408
(Willie Favero) You’re running DB2 for z/OS on the mainframe and you know all about the zIIP (System z Integrated Information Processor) specialty engine. You know that every MIP you can redirect to a zIIP has the potential to reduce your software cost because many products charge by the CPU capac
SELECT UNION Results INTO OUTFILE
(Jervin Real) Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, where do you put the the INTO OUTFILE clause? On the first SELECT, on the last or somewhere else? The manual has the answer here, to quote: