Kalen Delaney : internals

Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper

Kalen Delaney — Wed, 05 Jun 2013 16:42:00 GMT

Tech Ed isn’t even over yet, and my new Hekaton Whitepaper is already generating questions I can’t answer yet! Here are the two questions that were in my inbox this morning: 1. The whitepaper says “There are other wait types, such as waiting for a log...(read more)

Geek City: Document more trace flags?

Kalen Delaney — Mon, 03 Jun 2013 15:33:00 GMT

It’s been over 5 years since I last blogged about trace flags , so it seems a post on the topic is in order. If a trace flag is undocumented, it means it is unsupported and not guaranteed. It can go away at any time, even from one service pack to the...(read more)

Geek City: Accessing Distribution Statistics

Kalen Delaney — Fri, 18 Jan 2013 20:08:00 GMT

Distribution statistics are one of the most important sources of information that the Query Optimizer uses to determine a good query plan. In this post, I’m not going to tell you everything about distribution statistics. I’m just going to show you a few...(read more)

Geek City: What Triggered This Post?

Kalen Delaney — Tue, 01 Jan 2013 00:00:00 GMT

I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that...(read more)

Geek City: Growing Rows with Snapshot Isolation

Kalen Delaney — Sun, 20 Nov 2011 00:43:00 GMT

I just finished a wonderful week in Stockholm, teaching a class for Cornerstone Education. We had 19 SQL Server enthusiasts, all eager to find out everything they could about SQL Server Internals. One questions came up on Thursday that I wasn’t sure of...(read more)

Did You Know? I’ll be teaching my Internals Class online!

Kalen Delaney — Wed, 07 Sep 2011 20:27:00 GMT

In my most recent commentary for SQL Server Magazine, online here: http://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429 , I talked about different options for making training content available online. As an addendum...(read more)

Geek City: What gets logged for SELECT INTO operations?

Kalen Delaney — Tue, 15 Mar 2011 19:41:00 GMT

Last week, I wrote about logging for index rebuild operations. I wanted to publish the result of that testing as soon as I could, because that dealt with a specific question I was trying to answer. However, I actually started out my testing by looking...(read more)

Geek City: What gets logged for index rebuild operations?

Kalen Delaney — Tue, 08 Mar 2011 18:54:00 GMT

This blog post was inspired by a question from a future student. Someone who was already booked for my SQL Server Internals class in June asked for some information on a current problem he was having with transaction log writes causing excessive wait...(read more)

Did You Know: I'm going back to Boston!

Kalen Delaney — Wed, 26 Jan 2011 04:12:00 GMT

After spending 5 months in Boston last summer and fall, I'm going back again, to teach my 5-day SQL Server Internals and Query Tuning class for Boston SQL Training. Last time I taught my course there, we had a completely full class with a waiting list....(read more)

Geek City: Inside SQL Azure

Kalen Delaney — Tue, 02 Nov 2010 16:10:00 GMT

My new whitepaper has just been published! Inside SQL Azure http://social.technet.microsoft.com/wiki/contents/articles/inside-sql-azure.aspx The paper examines the internals of the SQL Azure databases, and how they are managed in the Microsoft Data Centers,...(read more)

TSQL Tuesday #11:Rolling Back TRUNCATE TABLE

Kalen Delaney — Tue, 12 Oct 2010 20:02:00 GMT

“It ain't what people don't know that hurts them it's what they know that ain't so” -- commonly attributed to Mark Twain SQL Server has been around for a long time now, and people who learn one version well sometimes have monumental task when a new version...(read more)

Did You Know: My Online Seminar Lasted Almost 5 Hours!

Kalen Delaney — Sun, 25 Jul 2010 00:06:00 GMT

Yesterday was a rebroadcast of the index internals seminar I presented last February, and I had forgotten how long it was. I was in a chat room the whole time, and the questions just kept coming, fast and (not so) furious! Thanks to all the participants...(read more)

Did You Know? I gave two presentations last week

Kalen Delaney — Mon, 14 Jun 2010 15:05:00 GMT

Even though I didn't make it to TechEd this year, it didn't mean I was quiet last week. On Wednesday, I was in Colorado, giving a talk for the new Colorado PASS User Group, which is a joint venture between 3 different existing groups from Colorado Springs,...(read more)

Did You Know? What PreCon would I take if I were attending TechEd?

Kalen Delaney — Tue, 18 May 2010 00:27:00 GMT

TechEd starts in 3 weeks, and I'm not going to make it this year. I had very much wanted to visit New Orleans post-Katrina and see the recovery for myself. I attended a couple of TechEd's there many years ago, but my primary reason for visiting that fabulous...(read more)

Geek City: More About Nonclustered Index Keys

Kalen Delaney — Mon, 08 Mar 2010 00:04:00 GMT

I thought I had said almost all that could be said about nonclustered index keys in a post made almost exactly two years ago , on March 16, 2008. But there's more. To get all the benefit from today's post, you'll really have to read that one, but I'll...(read more)