Trigger Happy Rotating Header Image


Query Tuning Scripts Prairie DevCon 2010

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.


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.

Intro Query Tuning Scripts

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:

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