No, I am not talking about Brittany Spears; one blog post could not possibly define or explain that child!
I am talking about SQL User Groups! I opened my mouth for a brief second and sure enough I was shocked and surprised by what came out of it.
“I will present at the November meeting.”
What the heck did I just say? What did I just volunteer my self to do? I really need to learn to take my wife’s advice. “Just say NO” LOL
Any way, on to picking a topic to present. One of the most intriguing things for me as a SQL DBA is performance tuning. The ability to push the limits and make queries go faster! I get excited when I figure out how to shave milliseconds of off of a query.
For me the best way to approach performance is to try and develop your queries and indexes correctly from the start. My presentation, “Indexes and Execution Plans”, will begin with a brief overview of indexes and execution plans; how to read them and to use them to your advantage in development. I will then give code examples on how to use execution plans to determine the best need (if any) for indexes.
My presentation and code will be available after the user group meeting.