ASP.NET Podcast Show #34 - Database Tuning
ASP.NET Podcast Show #34 - Database Tuning
Show Notes:
- Coach Wally.
- Bruce Dickinson returns.
- Explore the space of being Wally.
- You really want "More Wally" in the show.
- Paul Lockwood reviews podcasts.
- Oprah Effect? What about the Wally Effect!
- People all over the world.
- Amazon.
- Google Adsense.
- Wally begs you to help out.
- Interesting findings - Wally whines about paying big bucks for big companies but won't pay less for smaller companies.
- OrcsWeb.
- Wallyisms review.
- Database Performance and Tuning.
- Proper database design.
- Primary keys are good. I like integer data types.
- Foreign keys. FKs are used to relate data like customers and orders or Orders and order items.
- Normalization is good.
- Indexing is REALLY, REALLY important.
- Sql Server Profiler.
- Database Tuning.
- What happens when you don't have a good database design and proper indexing? Bad things.