SQL Notes (and other database related notes) - fcrimins/fcrimins.github.io GitHub Wiki

To SQL or NoSQL? That’s the database question (3/5/16)

• GREAT DB ARTICLE!!!

The Top 10 SQL Mistakes That Won't Scale (2/10/16)

1. Triggers
2. SELECT *
3. User Defined Functions
4. Dynamic SQL
5. Big Fields
6. Binaries in the Database
7. Heaps
8. Old Indexes
9. TempDB
10. V1 Features

You Probably don’t Use SQL INTERSECT or EXCEPT Often Enough