(Advait Deo) Oracle has come up with a feature called virtual index in oracle 9i. This feature allow us to test an index on a table without actually adding an index on the table.
Other News
DB2 Data Warehouse DSNZPARMS Part 1
(Dave Beulke) In the previous weeks I briefly talked about the new DB2 10 temporal tables and how they are great for data warehousing applications. To leverage the temporal tables and data warehousing applications within the DB2 for z/OS environment the system needs the proper DSNZPARM settings.
Quick Guide to .NET Framework Task Parallel Library Visual Studio 2010 Debugger
(Jeffrey Juday) Debugging is a frustrating experience. The last thing a developer needs is insufficient debugging support or difficulties operating the Debugger. Visual Studio has had intuitive debugging facilities for some time now. However the advent of Parallel Computing capabilities like the .NE
Productivity Enhancements in ASP.NET MVC 3
(Peter Vogel) As I discussed in earlier columns on ASP.NET MVC , I think that the chief issue organizations will be concerned with in adopting the tool will be developers’ productivity compared to ASP.NET.
OuterJoin with Filter Predicate
(Hemant K Chitale) I recently came across a query where an outer join was being used. Such an OuterJoin allows us to create a “dummy” row for the columns from a table where the join fails so that we can still present the values from the other table in the join.
Recommended Runstats Parameters
(Troy Coleman) SQL is a DB2 strongpoint, but it’s also central to the challenge of reducing the total cost of ownership of running DB2 on z/OS. Because it is so rich and powerful, DB2 needs to analyze the SQL — along with statistics gathered through the runstats utility — to determine the lowest c
Do You Need a SQL Server Query Hint?
(Kalen Delaney) SQL Server has supported the concept of query hints since the earliest version. However, in those versions there was such a small number of hints you could count them with your fingers.
SQL SERVER 2008 – 2011 – Declare and Assign Variable in Single Statement
(Pinal Dave) Many of us are tend to overlook simple things even if we are capable of doing complex work. In SQL Server 2008, inline variable assignment is available. This feature exists from last 3 years, but I hardly see its utilization.
Copy Database Wizard (MS SQL Server 2005 and later)
(Keshav Singh) Once at work, I came across a requirement where the development team needed the production database in the development environment as soon as possible. There were critical code changes to be tested without making any fuss about it.
Using B2B processing policy to route messages in the WebSphere DataPower XB60 Appliance: Part 2
(Bala Gopalan) B2B processing policy is a powerful new feature in the WebSphere DataPower B2B Appliance XB60. It enables you to assign a processing policy to each business partner profile to perform authentication, validation, filtering, routing, and transformation on B2B messages.