SAP MaxDB

Most folks working with SQL DBs for a while will likely come to see how beginners in this area struggle with “declaritive code” and “tell the DB what you want not how to do it” Read More » New year, same issues and some tips.

There is one predominant reason why databases and database technology get a spot in the conversation of “the business”: performance. Understanding system performance and coming up with ideas for improving it typically… Read More » How to know "all these things"

For many BW performance relevant DB-features, it’s really all about the details of usage and implementation when it’s about the effect of those features. The following are two examples of rather small things that went… Read More » Small changes with big effects

People use assumptions to make decisions. They do this all the time and insofar, developers are people as well :-) To be a bit more specific, also database developers make assumptions, One of them is for example that… Read More » MaxDB weekend magic - save 50% total storage space!

Ok, MaxDB is most often used with a NetWeaver on top of it, so this blog is about a niche topic of a niche product. Wow - that should be enough understatement and un-buzzing for now. Read More » MaxDB Optimizer Statistics handling without NetWeaver

One of the most important analytical tools used to investigate slow running SQL statements is the well-known ST05 - SQL trace. The idea of it is that the ABAP database interface notes down what SQL statement it sends to… Read More » MaxDB ST05-trace fallacy - when sometimes the trace is wrong...

Infrastructure software like RDBMS often tends to become feature-rich in many directions. MaxDB is no exception to this, so by reading the documentation there’s a pretty good chance to dig out some features that are… Read More » MaxDB Event Dispatcher Intro

As I promised here’s the second part of my short excurse into the shoals of lock management with MaxDB databases. (The first part can be found MaxDB - On locking mechanisms and how we get to know our MaxDB a bit better… Read More » MaxDB – On locking mechanisms and how we learn something new each day… Part II

One of the most boring topics within the area of DBMS surely is locking. It’s also one of the topics that most DB users try to avoid as much as possible. Still, it’s utmost important to correctly understand how locking… Read More » MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I