Category: PASS Chapters

SQLSaturday Round-Up (Jan. 27-Feb. 2)

(This is Round 10 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

PASS SQLSaturdays are appearing like clockwork - there's one for every weekend through to Apr. 9 (except there's still no event on Mar. 12 - anyone want to grab that spot before time runs out? No pressure!).

Last weekend it was Houston's turn to bring together SQL devotees for a day's worth of free training and networking. Not surprisingly, those folks in Texas did not disappoint - SQLSaturday #57 was a rocking success!

Houston didn't have any problems!

(We'd like to add that we're very proud of ourselves for not using the phrase, "Houston, we have a problem!" anywhere in that introduction.)

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK IN SQLSATURDAY...

Nancy Hidy helped organize SQLSaturday #57, Houston

Eric Humphrey presented at SQLSaturday #57, Houston

+ Jen McCown presented at SQLSaturday #57, Houston

+ John Sterrett presented at SQLSaturday #57, Houston

The mysterious SQL Avenger attended SQLSaturday #57, Houston

+ Sri Sridharan attended SQLSaturday #57, Houston

COMING UP IN SQLSATURDAY...

Like we said, there are still lots of SQLSaturdays to look forward to in February. On Feb. 5, there's a SQLSaturday in Cleveland, on Feb. 12 it's being held in Colorado Springs, on Feb. 19 you can attend the event in Phoenix, and on Feb. 26 it stops near PASS management HQ in Vancouver, Canada.

IN OTHER NEWS...

The PASS Board's January in-face meeting concluded in Dallas on Jan. 21. SQLSaturday was on the agenda - PASS Director Andy Warren ruminates about the meeting on his blog.

And finally, we'd like to remind everyone just how excited we are about what SQLSaturday has in store for the rest of 2011. There are fantastic events all over North America to look forward to - you should check the schedule and make sure you register in a city near you. After all, it's free!

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

PASS Update #50-January 2010 Board Meeting

[cross-posted from Andy Warren's blog at sqlandy.com]

This post is my thoughts on the Board meeting, and my views on related topics. I encourage you to read the minutes (not yet published) as the official documentation.

I flew into Dallas around noon on Wed, catching an early flight so I could get to The Joule hotel and spend a quiet few hours doing some prep for the meeting before the scheduled dinner with the Board. Cold when I arrived, maybe 45-50, enough to discourage me from much in the way of exploring beyond the Starbucks around the corner. Got a few things done, caught up on email and did some meeting preparation, and then back to the hotel to put stuff away prior to dinner. The hotel is one of those boutique type hotels, not the standard drywall and concrete, and with the one attribute I appreciate during travel, a great shower. Looking at lists prices it’s not cheap, but we ended up paying $169/night, a little higher than I’d like but in the range of acceptable for business travel.

Dinner was at the Iron Cactus immediately next door, fairly reasonably priced (my fajitas were $15) and where we had the strange experience of the waiter telling Tom LaRock to not to get the meatloaf. Good meal all in all. I spent some good time chatting with new Board members Allen Kinsel and Mark Ginnebaugh, and then Sri Sridharan from the North Dallas SQL Server User Group (NTSSUG)  joined as the end as well.

We spent a good chunk of Thursday looking at our global strategy, thinking about how we will grow and support SQLSaturday and SQLRally so that we can do some early sizing on the FY 2012 budget. Global growth brings complexity. An example is the SQLSaturday site is set up to manage money in dollars. Another is that if we move money across borders there may be tax implications on both sides. The next step is to learn some lessons by doing one or two, with our next step a SQLSaturday in Portugal, and then potentially a SQLRally in Sweden by the end of the year. We’ve also identified what we would like to have in time and resources, HQ will take that back and start looking at how to re-slice our current resource allocation to see if we want to do is possible.

We also talked about site selection for 2013. As I ‘m sure you know we’ve been in Seattle for a while and will be through 2012. Typically we sign contracts for space 2-3 years in advance, it’s the only way to be sure the space will be available within the date range we use for the Summit. Several months ago we built a list of around a dozen candidate cities. HQ has since done some research to help us understand what is available and the rough prices. At this meeting our task was to narrow the list to 3-4 cities. HQ will then send a formal RFP to those and we’ll start into the bake-off that should end with a site and a contract in March/April this year.

The list of cities is something we don’t publish in the minutes, and while we will announce when we sign the contract, we most likely will follow our previous pattern of not announcing the location until the end of the 2012 Summit. The rationale for this is that if people thinking about attending 2012 see that 2013 will be closer or in a more interesting location that they will defer attending for a year. From a pure business perspective maybe that makes sense, but I think it serves our members poorly. I see nothing wrong with letting them know 1-2 years out our plans. If they prefer to wait a year to save on travel, or to travel to a city they would like to visit, that’s good for them and ultimately good for PASS. I think it evens out year over year. More on this in a post later this week.

At 4:45 we started the journey across town to the monthly meeting of NTSSUG at the Microsoft office. Tom LaRock and I rode with Mark Sousa, Mark driving an F-150 he rented (only in Texas, right?), I was the navigator and Tom did the color commentary. We were worried about traffic and being late, but we arrived early and had a chance to mingle with the chapter members. We did a quick introduction of the Board, and then settled in to watch Sean McCown do a very nice hour class (part 1 of 6) on backup and restore strategy. That opening class has become part of their strategy to draw people in and it’s been effective. That was followed by Tom doing his presentation on wait states and queues.

After that we went to Red, Hot, and Blue for some ok barbecue, with a good handful of the chapter members joining us for discussion. It was cold out, had me wishing for home! We finished dinner about 10 pm and I called it a day when we got back to the hotel.

Friday morning we worked on our business plan and a “who we are” document, both are things I expect to see published in the next 30 days. The business plan was something that was largely done a year ago, but it didn’t quite make it out the door. Who we are, you might think, is something we should already know. 2 years ago PASS was the Summit and Chapters, today it’s the Summit, Chapters, Virtual Chapters (though to be fair we had them as SIG’s, but not very successful in my view), 24 Hours of PASS, SQLSaturday, and SQLRally (a work in progress to be fair, but still a big growth item). That’s a lot of change to absorb, and we’ve done it unevenly in places. That’s not unexpected or bad, it just means that we need to step back from growth mode and make sure we’re doing a good job and allocating appropriate time and resources to each area (which could mean adding more, or reducing).

We also need to make sure that you know what we see as our mission and where we’re spending time and money. My view is that we’re on step two of three or four on the path to being a “true” professional association. I don’t say that to dismiss our accomplishments or the work of our staff or volunteers. We’ve grown and matured, perhaps in more ways that we communicate. Yet many wish for PASS to be more. The hard part is that a full shared vision of “more” hasn’t evolved yet. At the heart of it is what we might do for members directly. Right now we have a strategy that is largely indirect – we build events, we facilitate, we connect, but we don’t a lot in the way of things that you can point to and say “my PASS membership means this and from I receive this and this and this”. I like our current strategy, I think it’s realistic, it’s functional, but it’s not sexy, and it’s still hard to explain to what I call the DBA in the back of the room, who says “why should I join?”. We can do more, I think a lot more, but the first step is to consolidate and make sure we do the things we do well. While we’re doing that we can be talking about what that next phase looks like that we might start 12-18 months from now.

On the time and money, Bill Graziano will be publishing more on that soon. We publish our budget, which has both too much and too little detail at times. We want to do more to show you how we apply resources to our various goals, and we want to make very clear what we contribute to things outside the Summit. I’ll write more in the next couple months to dig into what I get for resources for SQLRally and SQLSaturday.

We’ve been working on some revisions to the by-laws for several months and those should be published for review in the next week or so. Some of it is clean up and clarifying, making it very clear on things like term limits. We’ve removed the officer nomination committee which in the past nominated a “slate” that the Board would vote up or down, and instead it will be direct selection by the Board. We debated extensively moving to one year terms for officers. Not a one year limit, but a one year term. This is something I really believe in, I think it allows our Directors to step into a role and apply max energy. We’ll be publishing them for comment shortly, and I may add additional comments when we do.

Friday night I was lucky enough to have Tim Mitchell and Ryan Adams join me for dinner. Tim and I go back to SQLSaturday #3 and we just didn’t get much time to talk on Thursday, so it was nice to find some time in the week to talk more. Allen Kinsel was there, along with Mark Ginnebaugh and Bill Graziano. I was a spectator for part of it, listening to Bill chat with Tim and Ryan about chapters, and not for the first time wished we all talked more and more often.

Saturday morning I was up at 5 am for the taxi ride to the airport and the morning flight to Orlando, glad to be home.

 

SQLSaturday Round-Up (Jan. 20-26)

(This is Round 9 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

PASS SQLSaturday really hits its stride in the next few weeks. There's an event planned for every weekend through to Apr. 9 (except there's no event on Mar. 12 - anyone want to grab that spot?).

This past weekend SQLSaturday swung by Louisville. Early reports indicate the event organizers smacked a sweet SQL home run! 

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK IN SQLSATURDAY...

+ Kathi Kellenberger attended SQLSaturday #45, Louisville

+ Pam Shaw tried out a new registration process at SQLSaturday #62, Tampa

+ Brian K. McDonald presented at SQLSaturday #62, Tampa 

+ Julie Smith attended SQLSaturday #62, Tampa

COMING UP IN SQLSATURDAY...

As we mentioned earlier, there are lots of SQLSaturdays happening all over North America in the next few months. We don't want you to miss any of them.

Next Saturday, Houston hosts the event. On Feb. 5, there's a SQLSaturday in Cleveland, on Feb. 12 it's being held in Colorado Springs, on Feb. 19 you can attend the event in Phoenix, and on Feb. 26 it stops near PASS management HQ in Vancouver, Canada.

IN OTHER NEWS...

The PASS Board holds 2-4 in-face Board meetings per year. Since they usually coincide with a weekend, Director Thomas LaRock thought it would be a great idea if the Board held its meeting to coincide with a SQLSaturday, so let him know if you're interested!

Finally, few things can be a bigger boost to organizing your event than hearing what other successful SQLSaturday hosts have done (yes, the good and the bad) to make sure their events went off smoothly. Pam Shaw is a wily veteran, having already helped organize four SQLSaturdays, and she shares her thoughts on the process as a response to a wonderful blog post by another SQLSaturday veteran, Karla Landrum. Dig in!

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

 

 

SQLSaturday Round-Up (Jan. 13-19)

(This is Round 8 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

We took a bit of a hiatus over the holidays. Why? Because PASS SQLSaturday took a hiatus over the holidays. But that doesn't mean there wasn't feverish planning afoot, the most obvious example being SQLSaturday #62, held in Tampa on Jan. 15. This was the first SQLSaturday of 2011, but hold onto your hats, folks, because there are many more to come!

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK IN SQLSATURDAY...

+ Jose Chinchilla helped plan and host SQLSaturday #62, Tampa

+ Pam Shaw helped plan and host SQLSaturday #62, Tampa

+ Bradley Ball presented at SQLSaturday #62, Tampa

+ Denny Cherry presented at SQLSaturday #62, Tampa

+ Ronald Dameron presented at SQLSaturday #62, Tampa (and he has some important tips for newbie presenters)

+ Mike Davis presented at SQLSaturday #62, Tampa

+ Devin Knight presented at SQLSaturday #62, Tampa

+ Tim Radney presented at SQLSaturday #62, Tampa

+ Jason Bacani attended SQLSaturday #62, Tampa

+ Andy Warren attended SQLSaturday #62, Tampa

COMING UP IN SQLSATURDAY...

It's a brand new year which deserves great news about a brand new venue. Sure enough, Karla Landrum is overjoyed to announce that there will (at last) be a SQLSaturday in Hawaii! SQLSaturday #72 will take place in Honolulu on April 1. And there was much rejoicing!

Also, Thomas LeBlanc reminds everyone that SQLSaturday #57 is coming up on Jan. 29 in Houston.

IN OTHER NEWS...

The PASS Board will be discussing its SQLSaturday strategies as part of the agenda at the January in-face Board meeting, including plans for how the event should branch into foreign (i.e. non-North American) markets.

And to end on a friendly note, Andy Warren would like to introduce Malathi Mahadevan, a new blogger but experienced SQLSaturday planner. Malathi will help head up her second event, SQLSaturday #45, coming up this weekend (Jan. 22) in Louisville. Hi, Malathi!

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

 

In-Face Board Meeting - Agenda

For those who don't know, the PASS Board of Directors is currently gathering at the Radiant Salon in Dallas, TX, for an in-face meeting of the Board. Items on the agenda include the organization's international event strategy, Summit planning for 2011 and 2013, a number of critical amendments to the Bylaws, and the vision, scope, and long-term goals of PASS. 

The itinerary is posted below - minutes from this meeting will be posted in early February. 

PASS BOARD MEETING AGENDA 

Thursday, January 20th, 2011 

TIME ITEM
8:15 am to 8:45 am Opening & Welcome – Bill
8:45 am to 10:15 am International Events - Bill
10:30 am to 12:00 pm International Events, Cont. - Bill
1:00 pm to 3:00 pm Summit Planning 2011 – Rick H.
3:15 pm to 4:15 pm Site Planning for 2013 - Bill
4:15 pm to 4:45 pm Board Only Time - Bill

 

 

 

 

 

 


Friday, January 21st, 2011 

TIME ITEM
8:15 am to 9:15 am Bylaws - Bill & Hannes
9:15 am to 10:45 am Five Year Plan, Scope Document, Business Plan - Bill
11:00 am to 1:30 pm Five Year Plan, Scope Document, Business Plan, Cont. - Bill
2:30 pm to 2:15 pm Additional IT Proposal - Andy
2:15 pm to 3:00 pm Future Board Meeting Schedule - Bill

Feel free to leave comments here or on Twitter for any of the Directors or for the Board at large.

Cheers!

 

SQLSaturday Round-Up (Dec. 16-22)

(This is Round 7 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

After the conclusion of SQLSaturday #61 in Washington DC, held on Dec. 4, there are no more PASS SQLSaturdays until 2011. There's lots of news and helpful information in this post, though, so read on -- we'll go back to the future for one more week! (Why? Because that DeLorean is amazing. That's why.)

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK BACK TO THE FUTURE IN SQLSATURDAY...

Matt Velic attended SQLSaturday #61 in Washington DC (okay, this was in the past, but it's a great recap of the day's events)

Adam Jorgensen is the BI Iron Chef at SQLSaturday #62 in Tampa

Brian K. McDonald is speaking at SQLSaturday #62 in Tampa

COMING UP IN SQLSATURDAY...

Contrary to our post from last week, there are actually three SQLSaturdays in January and four SQLSaturdays in February. We forgot to mention that SQLSaturday #65 swings by near PASS HQ in Vancouver, Canada, on February 26. (Cheers to Gail Shaw for reminding us!)

IN OTHER NEWS...

SQLSaturdays can be stressful to host for many reasons. Karla Landrum provides some tips on reducing the stresses and costs of hosting these events. One way of putting a few extra dollars in your event's coffers is to have blog sponsorships -- as Noel McKinney explains, this is great for events and for bloggers.

And finally, with the holidays approaching quickly, a timely and relevant message from Kendal Van Dyke about how SQLSaturdays and other local SQL community events can help those less fortunate than we are. Definitely worth a read.

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

 

SQLSaturday Round-Up (Dec. 9-15)

(This is Round 6 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

After the conclusion of SQLSaturday #61 in Washington DC, held on Dec. 4, there are no more PASS SQLSaturdays until 2011. While we'll be going through a bit of withdrawal until then, it's worth noting that 2011 is looking like a booming year for SQLSaturdays, with 14 events already booked and many others rumored to be on the way. Until then, it's back to the future again for us!

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK BACK TO THE FUTURE IN SQLSATURDAY...

+ David Dye will be speaking at SQLSaturday #62 in Tampa

+ Denny Cherry will be delivering a pre-conference session at SQLSaturday #62 in Tampa

+ The mysterious Es Cue El is helping organize SQLSaturday #60 in Cleveland

COMING UP IN SQLSATURDAY...

There are three SQLSaturdays coming up in January alone. SQLSaturday #62 happens in Tampa on Jan. 15, SQLSaturday #45 in Louisville on Jan. 22, and SQLSaturday #57 in Houston on Jan. 29.

But being the little month that could, February refuses to be outdone - that month will also see three SQLSaturdays hosted: SQLSaturday #60 in Cleveland on Feb. 5, SQLSaturday #66 in Colorado Springs on Feb. 12, and SQLSaturday #47 on Feb. 19. 

And finally, Grant Fritchey recently announced that SQLSaturday #71 is a go in New England.

IN OTHER NEWS...

As we noted last week, SQLSaturday is a fantastic venue to hone your presentation skills. This week, John Sterrett points out that you don't have to be an expert to speak at SQLSaturdays

Of course, SQLSaturdays aren't just about speaking or learning - they're fantastic opportunities for meeting people and networking, and this week Andy Warren blogged about some real life anecdotes to inspire you.

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

 

SQLSaturday Round-Up (Dec. 2-8)

(This is Round 5 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

Only one PASS SQLSaturday was held in the past week, SQLSaturday #61 in Washington DC, but that doesn't mean we're short on blog posts! 

LAST WEEK IN SQLSATURDAY...

+ Kendra Little presented at SQLSaturday #61, Washington DC

Sandra Mueller presented at SQLSaturday #61, Washington DC

+ Ryan Rastedt attended SQLSaturday #61, Washington DC

COMING UP IN SQLSATURDAY...

2010's events are all done, but there are lots of SQLSaturdays coming up in 2011. If you're in the vicinity, don't miss SQLSaturday #62 in Tampa on Jan. 15 or SQLSaturday #57 in Houston on Jan. 29. PASS Director and speaker Andy Warren notes that SQLSaturday #62 is so popular that they've had to turn down speakers

And finally, Bob Pusateri announced that Chicago will be hosting SQLSaturday #67 on March 26.

IN OTHER NEWS...

SQLSaturday is a fantastic venue to hone your presentation skills. Brent Ozar blogged about these (and other) opportunities for up-and-coming speakers in 2011. 

For those about to host or thinking of hosting a SQLSaturday, you may be interested in Kathi Kellenberger's insightful interview with SQLSaturday #53 organizer, Bill Fellows

Before we go, we have to point you to this fantastic post by Wendy Pastrick. Wendy won the 2010 PASSion Award as PASS's most outstanding volunteer -- she blogs about how this came about and the role SQLSaturday played in her success. Congratulations again, Wendy! 

Want to attend a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

What's Your PASSion?

[Cross-posted from Wendy Pastrick's blog at wendyverse.blogspot.com]

It's a little late for a SQL PASS Summit 2010 recap, but I still wanted to share some of my experience from the event.

Each year, an award is given to a single recipient for displaying a passion in working with PASS and the SQL Server Community: The PASSion Award. This year, I was honored and humbled to be that person. Looking back at this past year, I'm dumbfounded to see all the things in which I became involved. It started with a letter sent to my current General Manager trying to justify my attendance at the Summit. What did I do? Started a new User Group in the Chicago suburbs, tried my hand at blogging, brought together Team SQL Saturday for the Chicago event, worked as co-chair for the Women In Technology Virtual Chapter, worked on the WIT Luncheon for the Summit, spoke at a few UG meetings and SQL Saturdays, and became a Regional Mentor for the Midwest. You know what, even looking at that list, I still feel that I didn't do all I wanted. Most of these things were (and still are) hard work, and yes, the ball gets dropped now and then. Looks like Michelangelo's theory is true: 

“The greater danger for most of us lies not in setting our aim too high and falling short; but in setting our aim too low, and achieving our mark.”

I started thinking 'What drives passion'? What motivates any one person to get out there and spend their spare time working on things that may or may not come to fruition? Taking a look inward, I have to say that I never intended to do any of these things with any tangible goals in mind other than "bring people together". As to the question of Why? - honestly it was more the fact that I had a an opportunity to work with really fun people who wanted to do the same things I did - so, I took it. Maybe I just got lucky that those opportunities happened somewhat simultaneously. However, looking at it more realistically, each one grew out of another.

Thank you to all the wonderful people I've met, worked with and studied from over this past year. You make it fun and worth doing!

So, go now, find your PASSion and have fun, plus meet like-minded people along the way! You really can get back out of it, sometimes even greater than, what you put into it.

Consider yourself tagged :)

[posted to PASS Blog by Hannes Bez on behalf of Wendy Pastrick]

 

Mr. LaRock Goes To Washington

[cross-posted from Thomas LaRock's blog at thomaslarock.com]

Well, technically I think we would just call it Virginia, but I am speaking this weekend at SQL Saturday #61. My talk is ‘Performance Tuning Made Easy’ and you can read a little bit more about it here.

I am always trying to find ways to help people who are new to MSSQL to understand the basics and give them a solid foundation to build upon. Performance tuning is hard for a lot of people because there is little to no structure put around the idea of performance tuning. My talk helps to give some structure where none previously existed.

I even spend some time going over a process to help anyone (newbies and veterans) have some structure when trying to tune a particular query. I borrow the SQL Diagramming method from Dan Tow and summarize that into a 12-step process. Why 12 steps? Because every other program I have entered has 12 steps so it just seemed natural. In my mind I wanted to create a process that anyone, no matter how many years of experience, could follow and have the end result be a step in the right direction. I’ll give you the rundown:

  1. List all tables in the query (what??? I don’t start by examining an execution plan? NO! you need some details first in order to be efficient in your tuning process)
  2. Gather rowcounts for each table (yeah, you’ll need this. I see people who dive into execution plans only to come back later to ask ‘how many rows in that table anyway?’, so do yourself a favor and get the info first)
  3. Find all filters (get info on the JOIN and WHERE clause of the query, list out the columns used)
  4. Calculate the selectivity (remember the rowcounts? good. now using the info from the filters, figure out how many rows are being returned from each table. So if we have an orders table with 12,000 orders but we filter to only want 3,000 of those orders, then our selectivity is 3,000/12,000 or 0.25)
  5. Gather info on any additional columns used (look in the SELECT clause for this)
  6. Gather info on existing keys and indexes (some newbies may not have any idea about this stuff but now is the time to learn. Dive in and make certain you are aware what exists currently)
  7. Examine the execution plan (finally! go ahead and run the query and examine the execution plan, use SET STATISTICS IO ON and SET STATISTICS TIME ON as well, you’ll want those numbers)
  8. Record your results from step 7 (otherwise how would you ever know if things are getting better?)
  9. Adjust the indexes for tables with the lowest selectivity first (by ‘lowest’ I mean the tables that are closest to zero from the calculation in step 4)
  10. Rerun the query and examine the results and execution plans
  11. Rinse, lather, repeat on each table in increasing order by selectivity
  12. Continue onward, reducing your logical and physical reads (you can focus on logical reads, ideally you wouldn’t have any physical reads. now is a good time to remind you that this is simply a process to help people get some structure around performance tuning, it isn’t meant to be something that is infallible for each and every query in existence)
  13. And now for the disclaimer: WARNING! ADDING ADDITIONAL INDEXES IS NOT ALWAYS THE RIGHT THING TO DO!

That’s right, you need to examine the other DUI (Deletes, Updates, Inserts) statements that are hitting those same tables. If you are working with tables that have lots of modifications being done then adding the additional indexes could hurt performance in other areas. Oh, sure, your query may run better, but you would have hosed someone else. And while I have come across MANY developers that don’t care about anyone else except their own performance I am here to tell you as a DBA it is your job to stand up and make certain that you help maintain a performance balance for all users, not just one user and one query.

I hope to see you this Saturday!