Kalen Delaney : query plans

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

Kalen Delaney — Tue, 11 Jun 2013 03:21:00 GMT

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)

Geek City: Join With Me!

Kalen Delaney — Thu, 14 Feb 2013 22:16:00 GMT

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)

Geek City: Ordered Seeks and Scans

Kalen Delaney — Fri, 21 Jan 2011 23:28:00 GMT

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)

Geek City: Plan Caching Internals

Kalen Delaney — Mon, 23 Aug 2010 17:04:00 GMT

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)

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

Kalen Delaney — Tue, 13 Jul 2010 14:02:00 GMT

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)

Did You Know: Good Stuff!

Kalen Delaney — Wed, 30 Jun 2010 21:33:00 GMT

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)

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

Kalen Delaney — Mon, 28 Jun 2010 03:40:00 GMT

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)

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

Kalen Delaney — Fri, 11 Jun 2010 22:46:00 GMT

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)

Did You Know? More online seminars!

Kalen Delaney — Thu, 22 Apr 2010 23:20:00 GMT

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)

Did You Know? I'll be at TechEd!

Kalen Delaney — Fri, 08 May 2009 17:23:00 GMT

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