Since SQL Server 2012, the FORMAT function has been a benefit to developers and DBAs, offering an easy way to convert dates and numbers to strings, akin to how it would be done in a language like C# or Java. After happily coding with the function for a number of years, performance has arisen as […]

Welcome to Adventure Works, DB2 for i! The DB2 for i database offers little in the realm of test data.  There is the ever popular QIWS.QCUSTCDT sample customer table and the CORPDATA sample database.   The CORPDATA database is decent in terms of design but the volume of data is negligible. In contrast, Microsoft SQL […]