UPDATE-6 July 2020: I have updated this post to be the landing page for all my posts on Open Source SQL Editors. There are many aspects of SQL editors that I will post in separate and probably smaller posts. Introduction Working in Business Intelligence (BI), I write and execute SQL statements every day. Actually it…Continue readingOpen Source SQL Editors
Category: SQL
Performance tuning SELECT statements can be a time consuming task which in my opinion follows Pareto principle’s. 20% effort is likely give you an 80% performance improvement. To get another 20% performance improvement you probably need to spend 80% of the time. Unless you work on the planet Venus where each day on Venus is…Continue reading6 Simple SQL SELECT statement performance tips
The first step when designing a fact table using Ralph Kimball’s dimensional modelling method is to decide on the grain of the table. Another way of describing the grain is the level of detail to store in your fact table. The accepted rule is that you should always store the data at the most detailed…Continue readingETL: Classify do not Filter out data
Categories
Visualising SQL Statements
Usually if I concentrate I am able to understand most SQL statements. There are times though such as: When a set of tables is not familiar When I did not write the SQL statement When the SQL statement is long and involves many tables and joins When I want to discuss a statement with a…Continue readingVisualising SQL Statements
Categories
Pivoting data in SQL
Most pivoting of data is done outside of the relational SQL databases. Relational databases are rigid and the variable number of columns in a pivot table is not something that goes hand in hand with the rigid structures defined in relational database. Pivot tables make some data just that much easier to work with. A…Continue readingPivoting data in SQL