Browse by Tags

• books
• conference
• indexes
• memory management
• metadata
• nonclustered index
• plan cache
• plan guides
• query tuning
• seminars
• showplan
• TechEd
• training
• T-SQL Tuesday

• T-SQL Tuesday: What kind of Bookmark are you using?

  I’m glad there is no minimum length requirement for T-SQL Tuesday blog posts , because this one will be short. I was in the classroom for almost 11 hours today, and I need to be back tomorrow morning at 7:30. Way long ago, back in SQL 2000 (or was it Read More... Posted Monday, June 10, 2013 9:21 PM by Kalen Delaney | 18 Comments Filed under: indexes, query plans, T-SQL Tuesday

• Geek City: Join With Me!

  I remember one of the most surprising changes in SQL Server 2000 2005 was how the graphical plans showed the use of a nonclustered index to seek, and the plan included something that looked like a JOIN to find rows in the base table. Here’s an example. Read More... Posted Thursday, February 14, 2013 3:16 PM by Kalen Delaney | 37 Comments Filed under: nonclustered index, indexes, query plans

• Geek City: Ordered Seeks and Scans

  I got a couple of really great questions during my SSWUG Workshop this morning , as I was discussing seeks and scans, and since the answers to the two questions are very related, I decided to address both of them in more detail in this blog post. Most Read More... Posted Friday, January 21, 2011 4:28 PM by Kalen Delaney | 29 Comments Filed under: training, showplan, indexes, seminars, query plans

• Geek City: Plan Caching Internals

  This Friday is the last of my summer seminars. On August 27, I am presenting on plan caching, plan reuse and recompile and plan cache metadata. This is one of my favorite topics to talk about, because a lot of the information is not very widely known, Read More... Posted Monday, August 23, 2010 11:04 AM by Kalen Delaney | 11 Comments Filed under: training, metadata, plan cache, seminars, query plans

• TSQL Tuesday #8: Those who can, do, and those who want to learn more, teach!

  It's time for the eighth T-SQL Tuesday , managed this time by Robert Davis at SQL Server Central . This time, the topic was announced very late, and I was just starting to write a blog post of my own when I saw it. Fortunately, my topic easily fits into Read More... Posted Tuesday, July 13, 2010 8:02 AM by Kalen Delaney | 16 Comments Filed under: showplan, query plans, T-SQL Tuesday

• Did You Know: Good Stuff!

  I know, I promised a technical post after my online seminar today, and I'm still planning on that. There weren't all that many really deep questions, just a lot of basic understanding questions, plus questions about topics I'll be covering in my Plan Read More... Posted Wednesday, June 30, 2010 3:33 PM by Kalen Delaney | 22 Comments Filed under: memory management, seminars, query plans

• Did You Know: My next web seminar is this Wednesday!

  I know, I haven't made a geeky post in a while... but I promise that I'll do one after this seminar. I'll take some of the best questions that I get during the chat and write them up here. Query Plans Workshop (June 30, 2010) Learn about basic elements, Read More... Posted Sunday, June 27, 2010 9:40 PM by Kalen Delaney | 11 Comments Filed under: training, showplan, seminars, query tuning, query plans

• Did You Know? I'm doing 3 more online seminars with SSWUG!

  As I told you in April , I recorded two more seminars with Stephen Wynkoop, on aspects of Query Processing. The first one will be broadcast on June 30 and the second on August 27. In between, we'll broadcast my Index Internals seminar, on July 23. Workshops Read More... Posted Friday, June 11, 2010 4:46 PM by Kalen Delaney | 11 Comments Filed under: training, plan cache, indexes, seminars, query plans

• Did You Know? More online seminars!

  I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they Read More... Posted Thursday, April 22, 2010 5:20 PM by Kalen Delaney | 12 Comments Filed under: training, books, plan cache, seminars, query plans

• Did You Know? I'll be at TechEd!

  I'm delivering a session on Tuesday morning (May 12) called "Controlling Your Query Plans", and for most of the rest of Tuesday, Wednesday and Thursday I'll be at the ATE (Ask the Experts) Area. Feel free to stop by! ~Kalen Read More... Posted Friday, May 8, 2009 11:23 AM by Kalen Delaney | 10 Comments Filed under: plan guides, conference, TechEd, query plans