(Karthikeyan Anbarasan) In this article we are going to see how to use a Row Sampling transformation in SSIS Packaging. Row sampling is used to randomly select some rows and move them as output to the required process as and when required to divide the rows.
Other News
An insider’s guide to star join optimization in IBM Informix Server
(Bingjie Miao) IBM Informix Server V11.70 introduces a star join optimization feature that can significantly increase query performance for queries on star schemas and snowflake schemas. This article explains how star join optimization works in IBM Informix Server, and how you can affect query optim
How to remove parent as a child from a SSAS parent child dimension
(Siddharth Mehta) In a parent child dimension, when an attribute’s usage type is set as Parent and browsed from a client tool, many designers as well as users may get confused based on the displayed results. For example, when you browse a parent attribute in a parent child dimension like Employee an
How to Remove Index Fragmentation
SelecTViews With Stephen Wynkoop Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] How to Remove Index Fragmentation Index fragmentation occurs when the contents of an index are not contiguous as it is stored […]
Custom XPath in SOA Suite 11g
(Antony Reynolds) Usually between standard XPath functions, BPEL extension functions and Oracle extension functions you have more than enough functionality, but sometimes you will need a little bit more.
A DB2 10 Upgrade DSNZPARM Tip / APAR
(Willie Favero) DB2 10 has a lot of very nice new features in it. One such feature is the ability to make LOAD, COPY, REORG, and REBUILD always use FLASHCOPY, even when not specified in the utility control cards.
SQL SERVER – 5 Tips for Improving Your Data with expressor Studio
(Pinal Dave) It’s no secret that bad data leads to bad decisions and poor results. However, how do you prevent dirty data from taking up residency in your data store? Some might argue that it’s the responsibility of the person sending you the data.
ASP.NET MVC and Multiple Submit Buttons–Part 2
(Malcolm Sheridan) My last article focused on how to have multiple submit buttons in the same form, and how to differentiate them in your action method. If you missed it you can read it here. If you want to hijack your form and post it via Ajax, you need to do some extra work. Controls that have a n
Automatically restarting MySQL slaves the easy way.
(Anders Karlsson) MySQL Replication is something that is used by many, many MySQL users, and here at Recorded Future we are no exception. In our case, the slaves are used for different purposes, and as we develop our system so much and so fast, so sometimes things happen which could have been avoide
MOXy Extensible Models – Multi-Tenant Example
(Blaise Doughan) In a multi-tenant architecture a single application runs on a server, serving multiple client organizations (tenants). Good multi-tenant applications allow per-tenant customizations. When these customizations are made to data, it can be difficult for the binding layer to handle th
