Hacker News new | ask | show | jobs
by xradionut 5409 days ago
Article assumes that a .NET developer will only be connecting to a MS SQL Sever database and not a third-party database like Oracle, Postgres or SQLite... Other than that it's not a bad article except the number one problem I see among developers that don't understand SQL Server is how and when to use indexes.
2 comments

A related problem is developers who do have a decent understanding of SQL Server then going to something like Oracle and thinking that all their best practices are still correct. You not only need to know about database generally, but you need to be familiar with how your SPECIFIC database works and how it's different from others you may have used.
I agree to xradionut. The article has good information but only a couple of index related links. The how, why and when of indexes will complete the article