New year, same issues and some tips.
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… Read More »New year, same issues and some tips.
SAP MaxDB
How to know “all these things”
How to learn about foundational techniques used in DBMS? This post provides some pointers to great free resources.
Small changes with big effects
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… Read More »Small changes with big effects
MaxDB weekend magic – save 50% total storage space!
People use assumptions to make decisions. They do this all the time and insofar, developers are people as well 🙂 To be a bit more… Read More »MaxDB weekend magic – save 50% total storage space!
MaxDB Optimizer Statistics handling without NetWeaver
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.… Read More »MaxDB Optimizer Statistics handling without NetWeaver
MaxDB ST05-trace fallacy – when sometimes the trace is wrong…
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… Read More »MaxDB ST05-trace fallacy – when sometimes the trace is wrong…
MaxDB Event Dispatcher Intro
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… Read More »MaxDB Event Dispatcher Intro
MaxDB – On locking mechsanisms and how we learn something new each day… Part II
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… Read More »MaxDB – On locking mechsanisms and how we learn something new each day… Part II
MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I
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… Read More »MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I
Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”
From time to time I start to believe that there are certain problems that would not come up anymore, once the topic is documented well… Read More »Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”