Learn about 7 common SQL mistakes to avoid when writing database applications, including blindly reusing queries, nesting views, running large multi-table operations in a single transaction, clustering on volatile columns, inefficiently counting rows, using triggers, and doing negative searches.
Table of contents
Blindly reusing queriesNesting viewsRunning large, multi-table operations in a single transactionClustering on GUIDs or other 'volatile' columnsCounting rows to check if data existsUsing triggersDoing negative searchesSort: