Disclosure: On this site you won’t find specific advice on “how to call function xyz()”. Interpreting C++ ARM and #pragma dwim is also out of scope.

We’re treating our readers as intelligent beings who can use Google and/or StackOverflow, where all such specific questions were answered more than once.

What you will find is opinions, more opinions, and even more opinions on all the aspects of software development - and with a large chunk of them based on real-world experience too.

Your mileage may vary. Batteries not included.

MOGdev: to feature branch or not to feature branch?

September 12, 2017 by “No Bugs” Bunny

bbbook_cover_vol04_-330.png

Quote:

As a rule of thumb, for gamedev we DO need to have our version control to be easily usable by non-developers.

Another Quote:

it is the second developer to commit who becomes a responsible for resolving conflicts

Filed under: Book: D&D of MOGs1st beta of Vol. I-IIIOn.DevelopmentDevelopment Processes

Read more

OLTP Optimization Cheat Sheets for dbdevs and DBAs

September 5, 2017 by “No Bugs” Bunny

Execution Plans with no index, single-column index, and multi-column index

Quote:

Have I already mentioned that you DO need to understand execution plans?

Another Quote:

DO keep in mind that maintaining indexes has its own cost

Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations

Read more

DB Execution Plans for C++/Java Developers, and for anybody who has read Knuth

August 29, 2017 by “No Bugs” Bunny

Execution Plans with no index, single-column index, and multi-column index

Quote:

If I was a compiler-with-ability-to-create-indexes-as-I-need-it – what would I do to make The Ideal Execution Plan™ for this request?

Another Quote:

When we have that ideal-execution-plan – we still need to convince our SQL compiler to use it

Filed under: Book: D&D of MOGs1st beta of Vol. VII-IX

Read more

Understanding Correlated and Uncorrelated Sub-queries in SQL

August 24, 2017 by “No Bugs” Bunny


Quote:

A correlated sub-query is a type of query, where inner query depends upon the outcome of the outer query in order to perform its execution.

Another Quote:

Correlated sub-queries are slower.

Filed under: On.ProgrammingTips and Tricks

Tagged With: SQLDatabase
Read more