Learning about execution plans. (intro)

by Allan Svelmøe Hansen January 09, 2008 07:34

Having entered the new year with all ten fingers and both eyes safe, I've started to turn my attention back to learning more about SQL and the tools provided by MS SQL server. I'm currently most interested in SQL, although I also am reading about .NET (mostly VB.NET) and other such things. 

I've started reading a number of books, blogs and other resources and the ultimate goal is that I improve my abilities within SQL and MS SQL Server to the degree where I feel comfortable enough in most of its aspects. Along the way I plan to try out for MCTS in SQL Server 2005 as I go along, however - unfortunately it is very much about administrate the server as well, which I'm not terrible interested in. My interests lies within the SQL, Query optimizing, indexes and all that - or at least, that is what I really would like to get good at. As good as all the "guru's" out there (well, not completely of course :))

So one step - outside reading - is that I want to try messing about understanding the tools. And my first tool I want to get into is the "Estimated Execution Plans". A good deal of optimizing in my experience starts here as it is a method to identify the issues with a query once it has been build. 

So that is my goal, and I'll try to dedicate a "series" of blog entries to this as I move along - so there is little to see in this entry about this yet. I do however hope as I find the time to mess about with this tool, that I'll gain the insight and ability to read it properly - cause at the moment it is very confusing, even if I have attempted to use it a couple of times.


So this will be mainly for my own benefit, but I'll try to document my way through here,  both so I have it for easy access for myself , but also in case I find something of interest.  

Bookmark and Share DotnetKicks dotnetshoutout

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Powered by BlogEngine.NET 1.6.1.0
Theme by Mads Kristensen | Modified by Mooglegiant

About:
Allan Svelmøe Hansen

My real name is Allan Svelmøe Hansen.
I live in Denmark, where I work as a developer for hedal:kruse:brohus using SQL Server and the .NET framework since 2004.
My primary fields of expertise is back-end data integration, database design and optimization.


       View Allan Svelmøe Hansen's profile on LinkedIn     

Disclaimer

The opinions expressed herein are my own personal opinions and thoughts and does not represent my employers view in any way, nor are my results guaranteed for all situations.
Content is presented "as is", with no warranty.