We had a consultant into work today… His name is Dan Sullivan (author of a number of SQL Server books). It was a super productive day. We spent time going over our database specifically looking at indices and how they impact (both positively and negatively). I guess I never really thought about how indexing works in a database, but it’s pretty cool. One of the more important things we learned is… “DON’T blindly follow the Database tuning advisor’s recommendations.” While the tuning advisor might suggest an index, it doesn’t know a lot about your data in the database so it makes suggestions on indices that don’t always make sense (ie if you have an int as a column that can only have 3 values… it probably doesn’t need to be included in the key).
Anyway. Tomorrow I should be breakingout the batching code I talked about last week.
