(Joseph Fuda) This tutorial demonstrates how aggregate functions deal with null values. Techniques for generating results that ignore nulls and results that include nulls are highlighted.
Other News
Managing Database Transactions with the TransactionScope
(Paul Kimmel) The TransactionScope is a lighter, faster way to enlist modifications to data in a transaction. But the TransactionScope is more powerful and its grasp extends beyond databases. The TransactionScope can enlist other things like COM+ objects in a transaction, and you will shortly see th
Death of the Relational Database … ha!
(Chris Eaton) I keep reading these articles over and over and over and it reminds me of when I was a kid. Back then people were saying that by the time I was old enough to drive there wouldn’t be cars anymore. We would all be driving around in flying vehicles. I watched the Jetsons with delight imag
Oracle 11g New Features SQL plan management (SPM)
(Virag Sharma) Case: You want to upgrade database from 10g to 11g and this change can cause regressions in SQL performance,and fixing them manually can be difficult and time consuming. Sql tuning can be used but, this is a reactive mechanism and cannot guarantee stable performance when drastic chang
Oracle 11g – CUBE_TABLE function for Oracle OLAP
(Venkatakrishnan J) If you are wondering how Oracle OLAP 11g exposes itself in the form of relational views, its all because of a new function called CUBE_TABLE. This function has been added new to 11g, to enable the OLAP cubes to be a part of the SQL Optimizer. This can be used on both Dimensions a
DB2 best practices for basic design, performance, and manageability
(Scott J. Martin and Colin J. Meiser) Over the past few years, much has been written about DB2 design and implementation best practices. There are many books, along with dozens of articles, that provide insight into how DB2 should be designed and integrated into applications. To provide some basic g
JAXB 2.0 offers improved XML binding in Java
(Peter Mikhalenko) Java Architecture for XML Binding (JAXB) 1.0 made it easier for developers to manipulate XML content from Java applications. This is achieved by specifying a binding of a XML document to JavaBeans objects based on the XML document’s XSD schema. The binding is easy to use and natur
What would make MySQL Multiple Queries Usable?
(Peter Zaitsev) MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network round trip in mind and got a little traction due to associated security risks and not significant gains in most cases.
String Functions: The .Properties Function
(William Pearson) In this, the first half of a two-part article, we will expose another useful function within the MDX toolset, the .Properties function. The general purpose of the .Properties function is to return a member property value. Enhancements to the .Properties function allow it go beyond
SQL Server 2005 Express: Beyond the basics
(Serdar Yegulalp) In my previous article about SQL Server 2005 Express Edition, I talked a bit about what the Express Edition was designed to address and how it eclipsed the SQL Server Desktop Engine as a lightweight way to make use of SQL Server power. This time around, I’m going to talk about some