Here are the scripts from the session. I hope you enjoyed it. Sorry that I got a bit carried away and didn’t quite finish. At the end of the demo script you’ll see that we were going to actually optimize a query… But the tools, and what to look for are the most important piece anyway. Feel free to post a comment or send me mail if you have any questions. Enjoy the rest of the conference.
Events
Winnipeg Code Camp 2010 Scripts
This post is for those who attended my session on query tuning at the Winnipeg Code Camp on Saturday, February 27.
I hope you enjoyed the session. Attached is the demo script I was using along with a setup script that will install the database I was using. Note that the setup script does some randomization, so the results will be similar, but not identical to what we saw in the session. Don’t hesitate to let me know if you have any questions.
Announcing March 2010 SQL Users Group Event
This month we will be hearing from Microsoft as part of their SQL Server 2008 R2 Community tour.
When: March 9th, 5:30 PM (The registration page says 6:00, but we’ll have doors open and food for 5:30)
Where: 17th Floor Conference Room, Richardson Building, One Lombard Place
SQL Server 2008 R2 Community Tour
SQL Server 2008 R2 is coming soon featuring several breakthrough capabilities that will enable your organization to scale database operations with confidence, help improve IT and developer efficiency, and enable highly scalable and well managed Business Intelligence on a self-service basis for your users. Come and find out how these changes will impact your role as database administrator and see first-hand some of the new capabilities demonstrated in this session being delivered by Damir Bersinic of Microsoft Canada.
You can register for this event here:
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032443664&Culture=en-CA
Announcing Winnipeg Code Camp
On Saturday, February 27th there will be a code camp in Winnipeg at the Red River College Princess St. campus. Details can be found at the code camp website. I will be giving a talk on query tuning:
Introduction to Query Tuning
Mike will go over the basics of query plans, query IO statistics and profiler output as tools for tuning a query. We will look at what considerations to make when deciding whether to create an index and what it means to INCLUDE a column. This is more of an introductory talk, but there will definitely be something there for anyone who doesn’t tune queries every day.
Be sure to register and come out – it will be a great day