4 ms·
Not a bad article but it needs a step 11: Know thy database engine for if you do not, your local DBA will be mightily pissed off when you do a cross join acros
by harrytuttle 13y ago
Not a bad article but it needs a step 11:
Know thy database engine for if you do not, your local DBA will be mightily pissed off when you do a cross join across 15 tables and watch his/her IOPS go through the roof...
- lukaseder 13y agoWell, to beginners it's always good to express things in a positive way. The "DBA rules" is part of the 2nd year of SQL experience tutorial :-)
- ams6110 13y agoThis is why you have a test instance for developers (or more likely now, every developer runs his own engine locally or in a VM).
- harrytuttle 13y agoThat's irrelevant as it usually only goes bang in production under production load and data volumes.
- Shivetya 13y agohow many platforms do not permit setting limits on processing of queries?