(Paolo Bruni, Felipe Bortoletto, Adrian Burke, Cathy Drummond and Yasuhiro Ohmori) Document the state of the art on DB2 transaction and subsystem monitoring.
Author: SSWUG Research
ADO.NET: More Aggregate Functions – COUNT, MAX, MIN, AVG
(Ged Mead) In this post, I introduced the SUM aggregate function. There are several others and I’ll quickly go through the more common of these in this post. In that earlier post, I showed you different ways of getting the same result.
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?
(Tanel Poder) Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though.
Identify Null Columns and Data Null Columns
(VidhyaSagar) I saw an interesting question in Facebook group. It’s all related to NULL values.. How to identify NULLable columns in a table and column with data as NULL. I thought of searching it in internet and pointing him to the link but I couldn’t get a reliable post to point it to the user so
Choose your Hash Bucket Count very wisely in Hekaton!
(Klaus Aschenbrenner) Today I have encountered a very simple blog posting where someone was inserting 1 millions of rows into a Hekaton Hash Index of 2048 buckets. Therefore I was running some tests how Hash Collisions in the Hash Buckets will affect the throughput of your Hekaton workload – and the
Using A Non-correlated Subquery To Avoid DISTINCT
(Tracy McKibben) Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I don’t get is why so many people (developers, I’m lookin’ at you) think DISTINCT is the only way to avoid it.
Introduction to XML and XSLT in C# .NET
(Pallavi Wasnik) When I started working on XML for my project, I was very new to the concept. Of course there are a lot of resources you can find on internet regarding how to read and write XML file in .NET, how to transform it in HTML file, how to change the existing XML file. But I didn’t find a […]
Carousel Image Gallery With AngularJS UI Bootstrap And ASP.NET MVC
(Brij) This article explains how to implement carousel image gallery with AngularJS UI Bootstrap and Entitiy Framework database first approach in ASP.NET MVC. Angular UI Bootstrap repository contains a set of native AngularJS directives based on Twitter Bootstrap’s markup and CSS.
MySQL in Amazon Web Services
(Mike Chapple) Looking for a free or very low-cost way to host your MySQL databases in the cloud? You may wish to consider hosting your database in Amazon Web Services.
How to find queries that use subpartition statistics
(Bobby Durrett) Yesterday I was trying to figure out if any queries on a particular production database were using subpartition statistics on a certain table. We are having trouble getting the statistics gathering job to finish gathering stats on all the subpartitions of this table in the window of