(Michael Paquier) Postgres 9.3 has introduced the first features related to materialized views. The upcoming version of Postgres is adding many basic things like the possibility to create, manage and refresh a materialized views. However, materialized views in Postgres 9.3 have a severe limitation c
Author: SSWUG Research
Shutdown/Startup vs. Alter Statement – 12c Edition
(Bobby Curtis) When everyone finally moves to Oracle pluggable databases, one thing to remember is that stopping and starting a database is not going to be as simple as it use to be.
12c: Exporting Database Views as Tables
(Amit Bansal) Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with the same columns as the view and with row data fetched from the view.
Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4
(Jeff Smith) “Explain Plans are useless.” Yikes. Really? Don’t we spend all day looking at execution plans?
Drill-down Behaviour in Power View
(Jason Thomas) I usually don’t write a lot of posts asking for favours from my readers (in fact, this is the first one), but an incident happened today at my client site which has aggravated a pet peeve that I have with Power View – drill-down behaviour in Power View.
Tips for Using the IBM DB2 Information Center Part 1: Navigating
(Ember Crooks) The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for. Unfortunately, sometimes you do not know exactly what you are looking for. A bit of knowledge about what is there, how it is organized, and how to most efficiently use the IBM DB2 Information C
Big Data: Five Ways to Get Analytics Started
(Dave Beulke) Last week I talked about five new data management perspectives that are driving Big Data. In Part Two of Big Data New Data Management Perspectives I would like to focus on the Big Data analytics.
A Glimpse into the Gut of your ASP.NET application
(Suprotim Agarwal) Some of us may have heard or used MiniProfiler a profiling library for your ASP.NET applications, from the StackExchange team.
Getting to grips with Regular Expressions: (2) Match and Match again
(Ged Mead) In this previous post, I looked at how you can use the Shared IsMatch method of the Regex class to find specified characters in a target or input string. Next, we’ll move from IsMatch to Match to find ways of searching for specific matches.
Binary Search Algorithm
(Richard Carr) The binary search algorithm provides fast searching within sorted arrays or collections. This iterative approach to searching disregards approximately half of the values in the collection with each pass to give O(log n) scalability.